| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a formula to perform multiple functions.
Steven
Week on starts from Row 3,. Week Cummulative Run KM Average 1 400 =IF(ISBLANK(B3),"",+B3-B2) =IF(ISBLANK(C3),"",AVERAGE(C$3:C3)) 2 850 =IF(ISBLANK(B4),"",+B4-B3) =IF(ISBLANK(C4),"",AVERAGE(C$3:C4)) 3 1150 =IF(ISBLANK(B5),"",+B5-B4) =IF(ISBLANK(C5),"",AVERAGE(C$3:C5)) 4 =IF(ISBLANK(B6),"",+B6-B5) =IF(ISBLANK(C6),"",AVERAGE(C$3:C6)) 5 =IF(ISBLANK(B7),"",+B7-B6) =IF(ISBLANK(C7),"",AVERAGE(C$3:C7)) TOTAL the answers would be Week Cummulative Run KM Average 1 400 400 400 2 850 450 425 3 1,150 300 383 4 383 5 383 TOTAL Best Regards Aqib Rizvi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a formula to multiple worksheets | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Multiple Functions IF, AND, COUNTIF, MATCH | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Hybrid Mode
