Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
my formula for the column total is =round(sum(a4:a15),2) but the answer is
wrong. I am adding 6.30+1.71+1.24 and it gives me a total of 9.27 (should be 9.28). The numbers in column are from a formula not numbers I just inserted and I think this may be my problem but I don't know how to solve it. The numbers are a result of a formula to calculate the GST from a number in another column. Help please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
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 | |||
Sum Function with wrong total shown | Excel Worksheet Functions | |||
My autosum total is incorrect - what is wrong? | Excel Discussion (Misc queries) |