ROUNDUP Function

C

Chacky

Can I use ROUNDUP to round up to the nearest 5.

If the answer to a calculation is 52, I want to round up to 55.

I know that ROUNDUP(52, -1) will round up to the next 10 i.e. 60
but can you round up to the nearest 5
 
R

Ron Coderre

Try this:

=CEILING(A1,5)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Roundup Function 5
Rounding by .05 4
Rounding up or down decimals to the nearest 5 2
roundup function 3
Round up to nearest 25 or 50? 6
RoundUp 4
Round-Up question 2
Divide a # into 3 #'s rounded to a whole # 9

Top