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