Can you set different rounding rules based off the last 2 numbers of a cell?

[c.clavin]

Hi guys, Im using a rounding formula to round to the nearest 25, but if the number ends in a 50 or 00, I want to make them 49 or 99 respectively. Is there a way to do this with a formula instead of going to helper columns? Thanks.

 

[Peter_SSs]

Im using a rounding formula to round to the nearest 25

What is your current formula?

 

[c.clavin]

The one I'm trying but isn't working is:

=IF(OR(RIGHT(Q3,2)=24,RIGHT(Q3,2)=74),SUM(L3+1),L3)

Im at a loss, very annoying

 

[c.clavin]

I had to put the 24 and 74 in "" quotes then it worked. Didn't think to. Guess because its the result of a formula?

 

[Peter_SSs]

I was asking for your existing rounding formula that rounds to the nearest 25.
The formula you have posted seems to have nothing to do with that.