Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need help with the table below:
The formulas in row 12 total rows 2-11 and read '=A11*55' etc etc. Problem is they are slightly off as shown in row 13. I have rows 2-11 formatted as numbers at 2 decimal point and row 12 formatted as currency at 2 decimal points. I tried putting '55' and '$55.00' in an individual cell and adjusting the formula to read 'Axx*Bxx' with the same results. Breakdown of Hours Based on Plowing Scenerio 1 A B C D E F Total(check) 2 0.98 n/a 0.36 n/a 0.16 n/a 1.50 3 1.11 0.30 0.40 n/a 0.18 n/a 2.00 4 1.00 n/a n/a n/a n/a n/a 1.00 5 1.27 0.35 0.46 n/a 0.21 0.21 2.50 6 0.00 0.00 0.00 0.00 7 0.00 0.00 0.00 0.00 8 0.00 0.00 0.00 0.00 9 0.00 0.00 0.00 0.00 10 0.00 0.00 0.00 0.00 11 4.37 0.65 1.22 0.00 0.55 0.21 7.00 12 $240.15 $35.76 $67.33 $0.00 $30.30 $11.46 $385.00 13 -$0.20 $0.01 $0.22 $0.05 $0.09 $0.17 row error |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Currency format | Excel Worksheet Functions | |||
Currency to Text | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |