I have the following formula to average the outcome of three calculations:
=IF(I24="","",ROUND(AVERAGE(E27*I26/F26,F27*I26/G26,G27*I26/H26),2))
How do I adapt the formula to ignore a zero outcome of any of the nested formulae?
e.g.
If (E27*I26/F26 , F27*I26/G26 , G27*I26/H26) worked out as (0, 5, 10), I want the average returned to be 7.5 rather than 5
Thanks in advance
=IF(I24="","",ROUND(AVERAGE(E27*I26/F26,F27*I26/G26,G27*I26/H26),2))
How do I adapt the formula to ignore a zero outcome of any of the nested formulae?
e.g.
If (E27*I26/F26 , F27*I26/G26 , G27*I26/H26) worked out as (0, 5, 10), I want the average returned to be 7.5 rather than 5
Thanks in advance