=AVERAGE((E5*1.05)/(E4*1.05),(E6*0.89)/(E4*0.89),(E7/E4)/(E4*60))
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"fivermsg" wrote in
message ...
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