Help Required please

[xxsalahxx]

I am using the formula below to try to get to a figure of 25, 50, 75, 100, how do I round the column up to show this? As at the moment its showing figures between 1- 100. Any help is much appreciated and i hope this makes sense to an excel expert!
=(AB2-1)*25
All figures in column AB2 are set between 1 and 5
Thank you in advance

 

[VoG]

Try

=CEILING((AB2-1)*25,25)

 

[xxsalahxx]

It worked!! Thank you so much

 

[xxsalahxx]

Thank you Vog, it worked!