View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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.