Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi!
I having 1 problem that Excel formula is calculating wrong total number on some of cells. For example: 1)M36=2.83 2)O36=ROUND(M36*1.075,2) 3)Q36=O36*110% 4)L36=1434 5)R36=L36*Q36 The R36 total is 4795.30 (wrong) When I used calculator to calcalate it, the correct total is 4789.56 (Formula is 3.34*1434=4789.56). May I know how to solve this problem? Please give advise. Thank you! Regards, Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating total number of days | Excel Worksheet Functions | |||
Formula total wrong | Excel Worksheet Functions | |||
Calculating Total Number of Minutes in a Clock Setting | Excel Discussion (Misc queries) | |||
total and subtotal positions wrong in excel | Excel Discussion (Misc queries) | |||
CALCULATING CELLS AS A TOTAL | Excel Discussion (Misc queries) |