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
|