How Do I Round Up After 5?

[JennJenn]

I am trying to round a number. For example, I need 25.365 to round up after the 5. Currently, 25.365 is only rounding to 25.36 instead of 25.37. Can anyone help with this?

Thanks

Somehow this is working now. I don't know what the problem was. Thanks.

[This message has been edited by JennJenn (edited 06-06-2002).]

 

[mdemarte]

Check your totals carefully, it may look fine but be really storing 25.365. Just in case, here's an example using two fields [quantity] and [rate]:

Int(([quantity]*[rate]*100)+0.5)/100