Devam Ediyor

482093 Excel Formulas

1) Excel formula for the following:

If AC is greater than 1.30 but less than 1.45 and AD minus AC is greater than 0.5 then show as W.

If AD is greater than 1.30 but less than 1.45 and AD minus AC is greater than 0.5 show as L.

Otherwise show 0

2) Excel formula for winning and losing runs.

I want to know the longest run of consecutive W and also the longest run of consecutive L

3) Sample data set

In the attachment is a sample of the data set on which you can use to test your equations and display the results to me.

Beceriler: Her şey Kabul, Excel

Daha fazlasını görün: less than excel, excel less than, excel w, Excel Formulas, excel formula, data set formula, excel test, formulas excel, formula test, test excel, test formula, sample excel test, attachment excel, excel sample test, sample data excel, excel display data, formula excel

İşveren Hakkında:
( 22 değerlendirme ) Australia

Proje NO: #2228003

Seçilen:

topfive

i m ready to work.

1 gün içinde 10$ USD
(0 Değerlendirme)
0.0