Hello

Can someone help with what should be a simple calculation? I sell material by the square foot. Any amount greater than a whole number needs to be rounded up to the next whole number. If the result is 10.1 I need the result to be 11.

Thanks alot.

This will do what you need:

Case(Int( NumberField )< NumberField ,(Int( NumberField )+1), NumberField )

You could have the round calculation add .5 to the number it intends to round-off & then it will always round to the higher integer.

For Example:

10.1 would become 10.6 & then round to 11

10.6 would become 11.1 & still round to 11

If I'm understanding what you're trying to do, then this should work...

Later,

Paul E. -)

quote:

---

Originally posted by dykstrl:

This will do what you need:

Case(Int( NumberField )< NumberField ,(Int( NumberField )+1), NumberField )

---

Thanks for the suggestion. Sorry I didn't reply earlier, I forgot to check for answers because I solved the problem myself.

quote:

---

Originally posted by PinnWal:

You could have the round calculation add .5 to the number it intends to round-off & then it will always round to the higher integer.

For Example:

10.1 would become 10.6 & then round to 11

10.6 would become 11.1 & still round to 11

If I'm understanding what you're trying to do, then this should work...

Later,

Paul E.

-)

---

Thanks for the suggestion. Sorry I didn't reply earlier, I forgot to check for answers because I solved the problem myself.