Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retail pricing to the $x.x9 or $x.x5
Ok, so digging through the forums I found
=ROUND(A1+0.01,1)-0.01 which will let me round a number to the nearest $x.x9 for retail pricing. What I would like to build into this formula (or if a macro would work better and easier) is to, in addition, make all $x.19 round up to the $x.29 AND all $x.09 round down to the $x.99. Any ideas? And for advanced pricing, I would like to go to the nearest $x.x5 or $x.x9. This one should be the easier of the two, but the two formulas are for two different applications. Don't mean to be a leech, but I can't figure it out and certainly someone else has already solved these formulas? Thanks, DotCom Factory |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cost to Retail Price Formula - some help pse | Excel Worksheet Functions | |||
Retail Pricing | Excel Discussion (Misc queries) | |||
Converting cost price to retail in vast array | Excel Worksheet Functions | |||
Retail Price rounding help needed | Excel Worksheet Functions | |||
Volume and pricing calculations | Excel Worksheet Functions |