Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula to round up to next higher multiple of 5
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula to round up to next higher multiple of 5
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula to round up to next higher multiple of 5
Try this:
=CEILING(A1,5) -- Biff Microsoft Excel MVP "LarryUSCGMWR" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the formula in excel for higher level of square roots | Excel Discussion (Misc queries) | |||
Round to multiple of 5 | Excel Worksheet Functions | |||
Why does Excel INT(x) behave like ROUND(x,0) for 10^14 and higher? | Excel Discussion (Misc queries) | |||
Replacing formula with round multiple times | Excel Discussion (Misc queries) | |||
multiple and round | Excel Worksheet Functions |