Devam Ediyor

482093 Excel Formulas

1) Excel formula for the following:

If AC is greater than [url removed, login to view] but less than [url removed, login to view] and AD minus AC is greater than 0.5 then show as W.

If AD is greater than [url removed, login to view] but less than [url removed, login to view] 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 excel, excel less, excel w, excel formulas, excel formula, data set formula, excel test, formulas excel, test excel, 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