Rounding up a number no matter what?! 1

[tbyrd1969]

Please help -

Using Filemaker 6.0, how can I get a calculation to round up to the next number no matter what the result is (as long as there is a remainder)?

i.e. - if we need 1700 widgets, but they only come in boxes of 500, I need to purchase 4 boxes, not 3 or 3.4.

Is there any way to do this? I can't figure it out!

Thanks - Mike

 

[jaco8867]

To always round up to the next nearest integer, the formula would be:

Round (Number + .499999, 0)

Hope that helps

 

[tbyrd1969]

Thanks a lot!

Sometimes the answer is easier than I expected. I got too hung up on formulas and operations - forgot about simple math!