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

  • Thread starter Thread starter LarryUSCGMWR
  • Start date Start date
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
 
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
 
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.

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.
 
Back
Top