Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to have prices that end in #58 or #98. So I need a formula that takes
a cost price of something and multiplies by 2.5 and then rounds it to a price that ends in 58 or 98. The final price could be as low as 58 and up to a 5 figure number ending in either of those 2 options which ever is the closer. If a figure were to fall at the half way mark ie 70 then it should round up to the 98. Hope this clear and thanks Eqa. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
ROUNDING | Excel Discussion (Misc queries) | |||
ROUNDING | New Users to Excel | |||
Rounding | Excel Discussion (Misc queries) |