Forum Discussion
Calculated "0" as an amount in Average function
My formula is =IF(F5-G4<0,"0"), this "0" result is part of an Average range. How do I format the "0" to calculate as a number within the range?
Example:
0:10:45
0:33:11
0
0
0
1:22:47
=AVERAGE(above range) which returns 0:42:14 in the HH:MM:SS format but is not calculating the zero as a number in the range.
Can anyone tell me what I am doing wrong. Thank you
Hi Kimberly,
Why don't you return zero as a number?
Hi. I tried that but the average comes back the same.
It shall be different, AVERAGE ignores any text
Perhaps something is with formatting. May you attach simple sample file?
