Help with formula to round up to next higher multiple of 5
"LarryUSCGMWR" wrote:
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.
|