Rounding Formula

[puppypants]

Is there a function that allows you to round a value up to the nearest
multiple of 5? I tried the round up function, but I don't think that is
going to work. I need to take the value of a cell (eg. 241 needs to
rounded up to 245) and round up to the nearest multiple of 5. Any
advise would be gretaly appreciated!

 

[Bob Phillips]

If you really mean round up, you can use

=CEILING(A1,5)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Earl Kiosterud]

Pants,

10 people will jump on this one; they always do. I'll make it 11.

=ROUNDUP(A2/5,0)*5

Earl Kiosterud
www.smokeylake.com

 

[puppypants]

Thanks Earl! You helped make me a hero at work...