Help with formula to round up to next higher multiple of 5

L

LarryUSCGMWR

Hi,

I am looking for a quick formula that can take a number and round it up to
the next higher integer that is a multiple of 5. Does anyone have a formula
for this. You can email me at (e-mail address removed) with any suggestions.

Thanks
 
J

Jacob Skaria

Try the below formula with your value in A1

=IF(MOD(A1,5)=0,A1,A1+(5-MOD(A1,5)))

If this post helps click Yes
 
J

JoeU2004

LarryUSCGMWR said:
I am looking for a quick formula that can take a number and round it up to
the next higher integer that is a multiple of 5. Does anyone have a
formula
for this.
Click to expand...

Ostensibly:

=ceiling(A1,5)

However, be careful about confusing displayed values v. actual underlying
values. Suppose your cell is formatted as Number with 0 decimal places, and
it displays as 5. You might be surprised if CEILING(A1,5) results in 10
because the underlying value is really 5.1.
 

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

Help! Rounding Up Formula 2
rounding a number up to a certain ending digit 6
MS Project Import Error Row 1 Column 5 2
Round up to next .5 5
Change Style to 'Keep with previous' instead of Keep with Next 1
Page numbering with Merged Document and IF statements 1
How to round down a value to the inferior multiple of 5 3
round up to the next 1/2 kg....formatting 0

Top