Rounding...

msk7777

Active Member
Joined
Mar 30, 2004
Messages
280
I have a column that has different prices that I need fomated to either roundup or down (examples: $75.46, $35.67 to $75.00, $36.00). How do you format the column to do this?

msk7777
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

hatman

Well-known Member
Joined
Apr 8, 2005
Messages
2,664
I don't think you can get there with formatting... have you tried the Round() function?
 

msk7777

Active Member
Joined
Mar 30, 2004
Messages
280
No I haven't, basically I just need the following prices rounded either down or up to the nearest dollar amount and I am not quite sure how to do this. Is there on formula that would round up and round down?
CDT-5 Compliant updated POS Schedules effective 01-01-2007.xls
DEFG
8Fee
9
10$18.53
11$29.43
12$30.52
13$80.00
14$21.80
15$23.98
16$53.41
17$9.81
18$7.63
19$15.26
20$20.71
21$19.62
22$10.90
CI-1
 

hatman

Well-known Member
Joined
Apr 8, 2005
Messages
2,664
in e10, enter
Code:
=round(d10,0)
and copy down... should get you there. Just be advised that the common rounding rules are applied, rather than the scientific/engineering rounding rules.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,484
Messages
5,529,135
Members
409,851
Latest member
Ingar
Top