| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to round down a value to the inferior multiple of 5
Hi,
Would like to know the formula to round down a set of values to their inferior multiple of 5. Exp: VAlues Round pretendended value $1256,00 $1255,00 $1349,00 $1345,00 $1599,00 $1595,00 $1614,00 $1614,00 Thank you for your help. jimmy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to round down a value to the inferior multiple of 5
Hi,
Try this =ROUND(A1/5,0)*5 but I don't understand your last example, typo perhaps. Mike "jimmy" wrote: Hi, Would like to know the formula to round down a set of values to their inferior multiple of 5. Exp: VAlues Round pretendended value $1256,00 $1255,00 $1349,00 $1345,00 $1599,00 $1595,00 $1614,00 $1614,00 Thank you for your help. jimmy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to round down a value to the inferior multiple of 5
OOPS,
My mistake you wanted to roound down, not to nearest. Try this =FLOOR(A1,5) Mike "Mike H" wrote: Hi, Try this =ROUND(A1/5,0)*5 but I don't understand your last example, typo perhaps. Mike "jimmy" wrote: Hi, Would like to know the formula to round down a set of values to their inferior multiple of 5. Exp: VAlues Round pretendended value $1256,00 $1255,00 $1349,00 $1345,00 $1599,00 $1595,00 $1614,00 $1614,00 Thank you for your help. jimmy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to round down a value to the inferior multiple of 5
HEllo Mike,
Thank you... It works. "Mike H" wrote: OOPS, My mistake you wanted to roound down, not to nearest. Try this =FLOOR(A1,5) Mike "Mike H" wrote: Hi, Try this =ROUND(A1/5,0)*5 but I don't understand your last example, typo perhaps. Mike "jimmy" wrote: Hi, Would like to know the formula to round down a set of values to their inferior multiple of 5. Exp: VAlues Round pretendended value $1256,00 $1255,00 $1349,00 $1345,00 $1599,00 $1595,00 $1614,00 $1614,00 Thank you for your help. jimmy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get MROUND to only round up to the next multiple. | Excel Worksheet Functions | |||
| Help with formula to round up to next higher multiple of 5 | Excel Worksheet Functions | |||
| Round to nearest multiple | Excel Discussion (Misc queries) | |||
| Round to multiple of 5 | Excel Worksheet Functions | |||
| multiple and round | Excel Worksheet Functions | |||
Linear Mode
