Rounding to the nearest hundred

B

Bob

I am looking for away to have currency values rounded to the nearest
hundreds. For example $25,762.14 would round up to $25,800.00 and $14,243.00
would round down to $14,200.00.

Any help would be appreciated.

Thanks, Bob
 
B

Bob

Thanks, it worked.

Ofer said:
Try this

format(format([MyNumber]/100,"#")*100,"#,###.00")

Bob said:
I am looking for away to have currency values rounded to the nearest
hundreds. For example $25,762.14 would round up to $25,800.00 and $14,243.00
would round down to $14,200.00.

Any help would be appreciated.

Thanks, Bob
Click to expand...
Click to expand...
 
Top