Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() how would i get the total of this equation (((E5*1.05)/(E4*1.05))+((E6*0.89)/(E4*0.89))+((E7/E4)/(E4*60))) to average?? meaning adding each inner equation and dividing by 3 won't work cause sometimes these inner equations will =0 ... I want the average of the inner equations omitting any zero values -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=521869 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Average formula | Excel Discussion (Misc queries) | |||
Formula to average certain times | Excel Discussion (Misc queries) | |||
Average Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |