View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sleepowers Sleepowers is offline
external usenet poster
 
Posts: 3
Default 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