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 |
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) |