Rounding UP Always in Excel

[knicholson@gpsx]

I need to round a dollar figure up to the next multiple of 5. This
would include the number 50. It should go to 55. Then the number 55
should go to 60, 56 should go to 60. I got the last two working but
that first one of rounding up 50, 51, 52, 53 and 54 is driving me
nutts???

 

[J.E. McGimpsey]

One way:

=CEILING(A1,5)

 

[knicholson@gpsx]

Got it figured out. =ceiling( [cell or forumula), 5)