How: Round to nearest 25

[blank]

I have formulas which give answers like 169, 181, 1131

Would someone please explain how to round the answers to 175, 175 1150
ie round up or down to nearest 25

 

[Biff]

Hi!

Try this:

=ROUND(A1/25,0)*25

1131.....1150

1131 will round to 1125

Biff

 

[bplumhoff]

Hi Biff,

Shorter:
=ROUND(A1*4,-2)/4

Regards,
Bernd

 

[blank]

thanks folks

 

[Biff]

The other method seems more intuitive.

If they have the ATP installed this may seem the most logical:

=MROUND(A1,25)

Biff