Rounding

[sam]

Hi,
I'm needing to use a value in a formula (in a function)
but requiring the value to be rounded up first. i.e
42.5250 should be rounded up to 43. can someone tell me
what to use to do this.

 

[jfp]

Use the Round() function (look in VBA help)

Try this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us%
3B97524

HTH

Jake