I have a formula reading:
=IF(G29 > 6, 0.5, 0)
G29 contains a value of 8.5 (calculated from it's own formula)
I would expect the above formula result value to equal .5
It's not; it equals 0
The formatting for G29 is number-format, 2 decimal places.
If I adjust the formula to read: