If entered number is odd, round up to even?

[bbevel]

Hi,

My app needs to automatically calculate the number of sheets of paper a print job will need so the requesting department can be charged accurately.

Most of my calculations work fine, but if the original document has an odd number of sheets, and the job requires going from 1-sided copies to 2-sided, I end up with an odd number of sides, and there's no such thing as a one-sided sheet of paper (Moebius strips not withstanding).

Example: Original has 3 single-sided sheets and the job wants them converted to double-sided. 3 / 2 = 1.5 sheets, which means 3 sides will be used.

Since the user enters the number of original sheets on their job ticket, how can I have Filemaker test the user's entered number of original sheets and correct it so that if an odd number is entered, FM will round that up to an even number?

I could instruct the users to round up to the next even number, but I'd prefer to have Filemaker handle it, since most users will forget to do this.

[mr_vodka]

Sheets + Mod ( Sheets; 2 )

[bbevel]

Thanks, John, I'll give that a shot!

[bbevel]

Beautiful, that did the trick - thanks!