Formulae Help

  • Thread starter Thread starter Karl
  • Start date Start date
K

Karl

is ther an easy way to do a division and always round up
ie
60 / 20 = 3
61 / 20 = 4

I did it by using the mod function

ie if a1 is the variable

= ((a1 - mod(a1,20))/20)+(if(mod(a1,20)>0,1,0))

but would guess somebody here would come up with something neater or better
 
There's a =roundup() function that you may want to look at:

=roundup(a1/b1,0)

And if you look at help, you can click on the Also link.

You'll see other rounding functions like =ceiling().
 
Back
Top