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), "")
Thanks for your reply, I have only just found it as the mail notification went straight to Junk folder!
Cell E12 contains a formula to calculate a result.
Cell F12 is a data entry only.
Can I apply the Round function with an existing formula in same cell?