Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding columns with decimals out to far
not sure how to explain, but I am totalling a column that has been multiplied
with another column and it has a 3 digit decimal, I can fix it to show only the 2 digits, but when I add the column up it is adding ALL of it... for example Column A Column B 30.00 (A*13.88%)=B 4.16(4) I can eliminate the (4) showing.. but it 30.00 4.16(4) still adds it in in the total at the bottom.. 30.00 4.16(4) total always add the 3rd digit.. I need it to round up/down EACH figure seperately, so when I add Column B up its should give me a total of 12.48 instead I get 12.49 Thanks MK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding columns with decimals out to far
Always then round your calculations to 2 decimals. Iso saying =A1*.88, or
A1*B1, where B1 = .88, use =ROUND(A1*.88,2) or =ROUND(A1*B1,2) -- HTH Kassie Replace xxx with hotmail "mastermk" wrote: not sure how to explain, but I am totalling a column that has been multiplied with another column and it has a 3 digit decimal, I can fix it to show only the 2 digits, but when I add the column up it is adding ALL of it... for example Column A Column B 30.00 (A*13.88%)=B 4.16(4) I can eliminate the (4) showing.. but it 30.00 4.16(4) still adds it in in the total at the bottom.. 30.00 4.16(4) total always add the 3rd digit.. I need it to round up/down EACH figure seperately, so when I add Column B up its should give me a total of 12.48 instead I get 12.49 Thanks MK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding columns with decimals out to far
Try this:
A1 = 30 =ROUND(A1*13.88%,2) -- Biff Microsoft Excel MVP "mastermk" wrote in message ... not sure how to explain, but I am totalling a column that has been multiplied with another column and it has a 3 digit decimal, I can fix it to show only the 2 digits, but when I add the column up it is adding ALL of it... for example Column A Column B 30.00 (A*13.88%)=B 4.16(4) I can eliminate the (4) showing.. but it 30.00 4.16(4) still adds it in in the total at the bottom.. 30.00 4.16(4) total always add the 3rd digit.. I need it to round up/down EACH figure seperately, so when I add Column B up its should give me a total of 12.48 instead I get 12.49 Thanks MK |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding columns with decimals out to far
"mastermk" wrote:
I can fix it to show only the 2 digits, but when I add the column up it is adding ALL of it Formatting only affects the __appearance__ of a cell value. It does not alter the underlying value. If you want the value to treated as having only 2 decimal places, I think the best method is to explicitly round expressions it yourself. 30.00 (A*13.88%)=B 4.16(4) I can eliminate the (4) The formula should be: =ROUND(A1*13.88%, 2) when I add Column B up its should give me a total of 12.48 instead I get 12.49 It is usually prudent to round sums of values -- all arithmetic formulas -- even if you rounded the individual values. For example: =ROUND(SUM(B1:B10),2) This solves a very different problem, one that frequently surprises people due to the way that Excel and most applications store numbers and perform arithmetic (binary floating point). Rounding ensures that "what you see is what you get". ----- original message ----- "mastermk" wrote in message ... not sure how to explain, but I am totalling a column that has been multiplied with another column and it has a 3 digit decimal, I can fix it to show only the 2 digits, but when I add the column up it is adding ALL of it... for example Column A Column B 30.00 (A*13.88%)=B 4.16(4) I can eliminate the (4) showing.. but it 30.00 4.16(4) still adds it in in the total at the bottom.. 30.00 4.16(4) total always add the 3rd digit.. I need it to round up/down EACH figure seperately, so when I add Column B up its should give me a total of 12.48 instead I get 12.49 Thanks MK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
Can surplus decimals be omitted when adding derived figures? | Excel Worksheet Functions | |||
Need help with Adding Decimals | Excel Worksheet Functions | |||
Parce a number with decimals into separate columns | Excel Discussion (Misc queries) | |||
Adding Decimals | Excel Discussion (Misc queries) |