Check CEILING() function.
? CEILING(8500/1800)
>Hi all,
>
>I need to calculate this to print in a report,
>
>Ex:
>I need to buy a product that my supplier only sales in multiples, like
>Art A = 1735
>Art B = 1800
>
>Then i have a need of 3000 for Art A and 8500 for Art B, how many multiples i need to buy???.
>
>The manual calculation is 3 for Art A and 5 for Art B, any chance to automate this?
>
--sb--