Rounding

[Guest]

I guess I am in the minority when I want rounding to occur. I just can't
figure out how. I have a database that tracks real estate contracts. I am
using the purchase price to calculate state stamp taxes via a query. The
formula is easy -

State Stamp: (([Total Purchase Price]/500)*0.5)

The trick is that the resulting number must always round up. So even if the
number is $421.01, it has to round up to $422.00. I'm not quite sure how to
do this. I would love to hear any suggestions.

Thanks!
Mark

 

[Guest]

Mybe there is another way but you can use that

format(format(MyNumber,"#,###"),"#,###.00")

the first formet round the number and the second one put to zero in the right.

 

[Van T. Dinh]

?Format(-Int(-421.01), "0.00")
422.00

?Format(-Int(-421.00), "0.00")
421.00