software

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 BCDEFTotal(check)
2 0.98 n/a0.36n/a0.16n/a1.50
3 1.11 0.300.40n/a0.18n/a2.00
4 1.00 n/an/an/an/an/a1.00
5 1.27 0.350.46n/a0.210.212.50
6 0.000.000.000.00
7 0.000.000.000.00
8 0.000.000.000.00
9 0.000.000.000.00
10 0.000.000.000.00
11 4.37 0.651.220.000.550.217.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 errorFirst, formatting, unless you have the quot;Precision as displayedquot; 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

www.mcgimpsey.com/excel/pennyoff.html

In article gt;,
Earl gt; wrote:

gt; I need help with the table below:
gt;
gt; The formulas in row 12 total rows 2-11 and read '=A11*55' etc etc. Problem
gt; is they are slightly off as shown in row 13. I have rows 2-11 formatted as
gt; numbers at 2 decimal point and row 12 formatted as currency at 2 decimal
gt; points. I tried putting '55' and '$55.00' in an individual cell and adjusting
gt; the formula to read 'Axx*Bxx' with the same results.
gt;
gt; Breakdown of Hours Based on Plowing Scenerio
gt; 1 A BCDEFTotal(check)
gt; 2 0.98 n/a0.36n/a0.16n/a1.50
gt; 3 1.11 0.300.40n/a0.18n/a2.00
gt; 4 1.00 n/an/an/an/an/a1.00
gt; 5 1.27 0.350.46n/a0.210.212.50
gt; 6 0.000.000.000.00
gt; 7 0.000.000.000.00
gt; 8 0.000.000.000.00
gt; 9 0.000.000.000.00
gt; 10 0.000.000.000.00
gt; 11 4.37 0.651.220.000.550.217.00
gt; 12 $240.15 $35.76$67.33$0.00$30.30$11.46 $385.00
gt; 13 -$0.20 $0.01$0.22$0.05$0.09$0.17 row error

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

quot;JE McGimpseyquot; wrote:

gt; First, formatting, unless you have the quot;Precision as displayedquot; checkbox
gt; checked in Tools/Options/Calculation, does not affect values stored in
gt; cells, nor values used in calculations.
gt;
gt; Second, if your values are calculated, see
gt;
gt; www.mcgimpsey.com/excel/pennyoff.html
gt;
gt; In article gt;,
gt; Earl gt; wrote:
gt;
gt; gt; I need help with the table below:
gt; gt;
gt; gt; The formulas in row 12 total rows 2-11 and read '=A11*55' etc etc. Problem
gt; gt; is they are slightly off as shown in row 13. I have rows 2-11 formatted as
gt; gt; numbers at 2 decimal point and row 12 formatted as currency at 2 decimal
gt; gt; points. I tried putting '55' and '$55.00' in an individual cell and adjusting
gt; gt; the formula to read 'Axx*Bxx' with the same results.
gt; gt;
gt; gt; Breakdown of Hours Based on Plowing Scenerio
gt; gt; 1 A BCDEFTotal(check)
gt; gt; 2 0.98 n/a0.36n/a0.16n/a1.50
gt; gt; 3 1.11 0.300.40n/a0.18n/a2.00
gt; gt; 4 1.00 n/an/an/an/an/a1.00
gt; gt; 5 1.27 0.350.46n/a0.210.212.50
gt; gt; 6 0.000.000.000.00
gt; gt; 7 0.000.000.000.00
gt; gt; 8 0.000.000.000.00
gt; gt; 9 0.000.000.000.00
gt; gt; 10 0.000.000.000.00
gt; gt; 11 4.37 0.651.220.000.550.217.00
gt; gt; 12 $240.15 $35.76$67.33$0.00$30.30$11.46 $385.00
gt; gt; 13 -$0.20 $0.01$0.22$0.05$0.09$0.17 row error
gt;

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 quot;numbersquot;.

In article gt;,
Earl gt; wrote:

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

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 quot;=c 12 c 13quot; to arrive at a total mileage then
quot;=c22/c25quot; 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 quot;=g16*55quot;

Thanks.

quot;JE McGimpseyquot; wrote:

gt; What values and formulas are in the input cells?
gt;
gt; Are any of the cells Text (which SUM() ignores)? Pasted-in data is a
gt; frequent source of text-entered quot;numbersquot;.
gt;
gt; In article gt;,
gt; Earl gt; wrote:
gt;
gt; gt; Thanks, but I have basically the same results. I can understand a penny but
gt; gt; some are 20 cents off.
gt;