Division after >=

[stepha]

I am trying to take an amount from one column, if it is less than 50, to show 1 and if it is more than 50, to divide by 50 and then round up so there isnt any decimal points. Some values in the first column are upwards of 750 and some are 1. Can anyone help me? I don't even know where to start!

 

[Jonmo1]

Welcome to the board..

Try

=MAX(1,ROUNDUP(A1/50,0))

or actually, if the value will never be a Negative, then you don't even need the max, this will do.

=ROUNDUP(A1/50,0)

 

[stepha]

Thank you SO MUCH!!! I can't believe how quickly you helped me, I have been struggling with this all morning.