My formula gives a wrong total...help!

[Sleepowers]

My formula is this: =F28-SUM(G28:K28)
My cell contents are: F28 = 682.59, G28 = 42.32 (a calculated number of 6.2%
of F28), H28 = 9.90 (a calculated number of 1.45% of F28), I28 = 102.39 (a
calculated number of 15% of F28), J28 = 20.48 (a calculated number of 3% of
F28) and K28 = 7.51 (a calculated number of 1.10% of F28). The total should
be $499.99, but instead comes out to $500.00. Please advise how to make this
formula total correctly. Thank you, Sandy

 

[Dave Peterson]

J.E. McGimpsey explains it and offers a solution:
http://mcgimpsey.com/excel/pennyoff.html

 

[Sleepowers]

Thank you Mr. Peterson, changing to Precision as Displayed worked. The one
cent difference is now gone. You are a miracle worker!

 

[Dave Peterson]

Remember that you can't recover from that option.

But JE does nice work, huh??