A
AndyS
How can I Always ROUND UP, a number to a multipal of 5 in excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bearacade
=ceiling(a1,5)
Hth
Hth
F
Franz Verga
AndyS said:How can I Always ROUND UP, a number to a multipal of 5 in excel
=-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
=ceiling(roundup(d4,0),5)
where the number you want rounded up to a multiple of 5 is in cell d4
A
AndyS
thanks I had tried this but needed to alter in order to make it work thanks
again
again