Formula

[Andrea Pelletier]

I need to create a formula in my spreadsheet that says -
If the number in A1 is between 0-24, enter 25. If the
number in A1 is between 25-49, enter 50. If the number in
A1 is greater than 50 round up to the nearest 100 (i.e.
if A1 is 75 it would round to 100, if A1 is 625 it would
round to 700)

 

[Roger Govier]

Hi Andrea

Try
=IF(A1>50,CEILING(A1,100),IF(A1>25,CEILING(A1,50),25))