How can I always ROUND UP to the nearest multipal of 5 in excl

F

Franz Verga

AndyS said:
How can I Always ROUND UP, a number to a multipal of 5 in excel
Click to expand...


=-INT(-F16/5)*5

--
(I'm not sure of names of menus, options and commands, because translating
from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
B

Bud

Try this ...
=ceiling(roundup(d4,0),5)
where the number you want rounded up to a multiple of 5 is in cell d4
 

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

Can you write a formul that will put multipal answers in multipal. 1
Rounding Time to Nearest 5 Minutes 1
Round Function 5
Round Question 3
rounding up to the nearest 1000 1
Alternate Rounding Up & Down of .50 in a column 5
Rounding numbers up or down in same formula 6
Rounding Time. 4

Top