Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rounding up numbers
This may seem trivial as I am not to advanced in excel, but I need excel to
round up at .50 (as it stands right now if I have $3854.50 when I format the cell to 0 decimals it rounds down to $3854) my company rounds up at that number. Anybody know how to change that? Thanks! |
#2
|
|||
|
|||
Hi Michelle
formatting a cell doesn't actually round numbers it just supresses the display of the decimals (to test this, format your cell to show 3854.50 as 3854 and then in another cell multiply this formatted number by 100) to round a number, use the round function e.g. =ROUND(A1,0) to round to no decimal places -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Michelle Nichols via OfficeKB.com" wrote in message ... This may seem trivial as I am not to advanced in excel, but I need excel to round up at .50 (as it stands right now if I have $3854.50 when I format the cell to 0 decimals it rounds down to $3854) my company rounds up at that number. Anybody know how to change that? Thanks! |
#3
|
|||
|
|||
By default, 3854.50 will round up to 3855. If your value is calculated,
try expanding the number of decimal places. I'll bet you'll see something like 3854.499, which displays as 3854.50. One possible solution: =ROUND(A1+0.005,0) You might want to take a look he http://www.mcgimpsey.com/excel/pennyoff.html In article , "Michelle Nichols via OfficeKB.com" wrote: This may seem trivial as I am not to advanced in excel, but I need excel to round up at .50 (as it stands right now if I have $3854.50 when I format the cell to 0 decimals it rounds down to $3854) my company rounds up at that number. Anybody know how to change that? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
How do I stop rounding numbers? | Excel Discussion (Misc queries) | |||
Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |