Forum Discussion
Solved
Calculating formulas to make an IF function work correctly.
Setting up a file to track hours and provide estimates I need for holding back funds. Column C is number of hours. Entries will be in quarter our increments. Column E multiples the value in C * cel...
That is so called floating point error. You may change your check sum formula on something like
=IF(ROUND(R20-E20,5)=0,"YES","NO")
That is so called floating point error. You may change your check sum formula on something like
=IF(ROUND(R20-E20,5)=0,"YES","NO")SergeiBaklan Thank you. I had looked at rounding, but only from the aspect of applying internal to each calculation. This is much more efficient. I appreciate the help.
