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 =AVERAG...
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?