ROUND UP

[KW]

Does anyone know how I can round a number up to the next multiple of 20. i.e either 20, 40, 60, 80, 100 etc. I can get it to round up to the next 10 using the ROUNDUP function, but not to the next multiple of 20.

 

[Scott Huish]

Hi, welcome to the board!

If you have the Analysis Toolpak installed:
=MROUND(F1,20)

EDIT: If not, see Mel's response

 

[Mel L]

try

=ceiling(a1,20)