Round value as per range

[AdnanHalai-un]

Hi Team,

while working on 1 of the working sheet, we are facing issue with numbers.

eg:
If last 2 digit is between 0-25 : then number should be round to 00
If between 26-50: 50
If between 51-75: 50 (552 should be 550)
If between 76-99 : +1 (577 should be read as 600)

 

[Peter Bartholomew]

You will be pleased to know that there is an Excel function, specific to this task
= MROUND(+value, 50)
The + was only needed because I chose to define 'value' to be a multi-cell range containing several values to test.

 

[pecoflyer]

Are you talking about decimal values or integers ?