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
---------------
Jacob Skaria
"LarryUSCGMWR" wrote:
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 with any suggestions.
Thanks