My formula gives a wrong total...help!
 

My formula is this: =F28-SUM(G28:K28)
My cell contents a 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

My formula gives a wrong total...help!
 

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

Sleepowers wrote:

My formula is this: =F28-SUM(G28:K28)
My cell contents a 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

My formula gives a wrong total...help!
 

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

"Dave Peterson" wrote:

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

Sleepowers wrote:

My formula is this: =F28-SUM(G28:K28)
My cell contents a 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

My formula gives a wrong total...help!
 

Remember that you can't recover from that option.

But JE does nice work, huh??

Sleepowers wrote:

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

"Dave Peterson" wrote:

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

Sleepowers wrote:

My formula is this: =F28-SUM(G28:K28)
My cell contents a 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


--

Dave Peterson