Rounding...

[msk7777]

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

 

[hatman]

I don't think you can get there with formatting... have you tried the Round() function?

 

[msk7777]

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
	D	E	F	G
8	Fee
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]

in e10, enter

=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.