Forum Discussion
Solved
excel calculation not equalling what it should?
I have a simple spreadsheet or at least I thought it was! I have cell E12 which is a formulated figure £61.99 Cell F12 is the amount paid £62.00 cell G12 is sum of F12-E12, which gives result of 0.0...
Change the formula to
=IF(F13<>"", ROUND(F13-E13, 2), "")
or
=IF(F13<>"", ROUND(F13, 2)-ROUND(E13, 2), "")
Yes, change
=expression
to
=ROUND(expression, 2)
here is the formula i have
=IF(F13<>"",(F13-E13),"")
Change the formula to
=IF(F13<>"", ROUND(F13-E13, 2), "")
or
=IF(F13<>"", ROUND(F13, 2)-ROUND(E13, 2), "")
Hans your're a genius!! the second option was the solution that worked, the first just left the cell blank?
I'll be sure to remember the advice I have received by all on the ever decreasing decimals that Excel uses.
Great help, thanks all.