Rounding down and up Numbers

[ianmuir]

At the end of my invoice is a Total field (calculation) which adds up the various bits of the invoice.

If the total is done with a calculator it differs from the filemaker total by 1 at the end. I need to make it so if the last number < 5 it rounds down and if its > 5 it rounds up.

Any ideas?

[Fitch]

Are you saying that Round doesn't work?

PS: In my experience it's almost always best to round the invoice items rather than the total.

[ianmuir]

I will have a go, thanks. Can you supply an eample of using Round?

[mr_vodka]

Did you click the link that Tom provided in his post?