| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding a number down to the nearest 5?
I want to be able to have numbers in excel round down to nearest 5. Example
296 down to 295 or 294 down to 290. |
|
#2
|
|||
|
|||
|
One way
=FLOOR(A1,5) Regards, Peo Sjoblom "maluli" wrote: I want to be able to have numbers in excel round down to nearest 5. Example 296 down to 295 or 294 down to 290. |
|
#3
|
|||
|
|||
|
That works perfectly. Thanks for you input Peo!!
"Peo Sjoblom" wrote: One way =FLOOR(A1,5) Regards, Peo Sjoblom "maluli" wrote: I want to be able to have numbers in excel round down to nearest 5. Example 296 down to 295 or 294 down to 290. |
|
#4
|
|||
|
|||
|
My pleasure, thanks for the thanks
Regards, Peo Sjoblom "maluli" wrote: That works perfectly. Thanks for you input Peo!! "Peo Sjoblom" wrote: One way =FLOOR(A1,5) Regards, Peo Sjoblom "maluli" wrote: I want to be able to have numbers in excel round down to nearest 5. Example 296 down to 295 or 294 down to 290. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers up or down | Excel Discussion (Misc queries) | |||
| Rounding to the nearest 9th | Excel Discussion (Misc queries) | |||
| How do I keep a value from rounding up to the next number? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
