Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formula is calculating wrong total number on some of cells | Excel Worksheet Functions | |||
addition total is wrong | Excel Worksheet Functions | |||
Sum Wrong total but add each cell gives the correct total | Excel Worksheet Functions | |||
Counta problem - Wrong total | Excel Discussion (Misc queries) | |||
Formula total wrong | Excel Worksheet Functions |