Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding down to positive when adding cells
When I am adding two cells excel wants to round down to a positive number. I
have tried to use the accounting and the currency function with no success. Example would be =C5 ($23.81) + E5 (23.82) I get $47.62 not $47.63 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding down to positive when adding cells
What is probably happening is those number have extra precision beyond the 2
decimal's displayed. e.g. C5 might be 23.805 and E5 might be 23.818. When you add these numbers you will get 47.62 when rounded to 2 decimal places (even though it APPEARS you should get 47.63 when you add the rounded versions). If you really want to get rid of the extra precision in C5 and E5 do the following: <Tools <Options "Calculation" tab Check "Precision as displayed" This will calculate based on the amount of precision you choose to display in the cell. Does that help? -- Regards, Dave "billatmei" wrote: When I am adding two cells excel wants to round down to a positive number. I have tried to use the accounting and the currency function with no success. Example would be =C5 ($23.81) + E5 (23.82) I get $47.62 not $47.63 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding down to positive when adding cells
I expect the numbers are not exactly 23.81 and 23.82 but maybe something
like 23.808 and 23.816. These add to 47.624 which gets displays as 46.62 when the format is 2 decimals. How to get what you want? a) =ROUND(C2,2)+ROUND(E2,2) OR b) Tool | Options | Calculations and check Precision as Displayed While (a) is more work, you must be careful that (b) may affect other workbooks that you open. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "billatmei" wrote in message ... When I am adding two cells excel wants to round down to a positive number. I have tried to use the accounting and the currency function with no success. Example would be =C5 ($23.81) + E5 (23.82) I get $47.62 not $47.63 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding cells witht the same name | Excel Discussion (Misc queries) | |||
Adding up multiple cells | Excel Worksheet Functions | |||
Adding cells with the same color, sub works but function doesnt | Excel Discussion (Misc queries) | |||
adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) |