Currency formula/formatting problem

[Guest]

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

 

[JE McGimpsey]

First, formatting, unless you have the "Precision as displayed" checkbox
checked in Tools/Options/Calculation, does not affect values stored in
cells, nor values used in calculations.

Second, if your values are calculated, see

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Guest]

Thanks, but I have basically the same results. I can understand a penny but
some are 20 cents off.

 

[JE McGimpsey]

What values and formulas are in the input cells?

Are any of the cells Text (which SUM() ignores)? Pasted-in data is a
frequent source of text-entered "numbers".

 

[Guest]

I basically have 4 tables: 1) the main road and each driveways distance in
miles 2) a pro-rata table that has the share (in miles) that each represents
depending on which is plowed 3) the hours plowed 4) the table I originally
posted that computes totals in dollars per event using pro-rata mileage
multiplied by an hourly rate

Formatting: all are number, rounded to two places except for a the total row
in table 4 that is currency, rounded to two places.

Formulas: table 2 has "=c+12+c+13" to arrive at a total mileage then
"=c22/c25" for individual values divided by the this total for the pro-rata
scenarios that can change and table 4 uses these values to apply to the hours
to arrive at individual breakdown in hours then sums them in the column, then
applies the hourly rate by "=g16*55"

Thanks.