| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
round up
Hi all,
I am doing the prices for my products and I end with numbers like 123 or 449 is there a way where we can round the lat digit in the right to be either zero or 5 which is nearer like 123 to become 125 & 449 to become 450. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up
Maybe
=ROUND(A1/5,0)*5 Mike "firroo" wrote: Hi all, I am doing the prices for my products and I end with numbers like 123 or 449 is there a way where we can round the lat digit in the right to be either zero or 5 which is nearer like 123 to become 125 & 449 to become 450. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
round up
Thank you Mike it works very well.
Regards "Mike H" wrote: Maybe =ROUND(A1/5,0)*5 Mike "firroo" wrote: Hi all, I am doing the prices for my products and I end with numbers like 123 or 449 is there a way where we can round the lat digit in the right to be either zero or 5 which is nearer like 123 to become 125 & 449 to become 450. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round up to 3 | Excel Discussion (Misc queries) | |||
| Don't Round... | Excel Discussion (Misc queries) | |||
| Round up down or anywhere | Excel Discussion (Misc queries) | |||
| @ROUND | Excel Worksheet Functions | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
