Folks,
I am trying to do the following:

I am looking at MSRPs for our products ..for example Product A comes with a
Base price of $71.16..Product B comes with a price of $54.78. I am trying to
round the end number to a 7 or 9...therefore, Prod A becomes $71.17 and
Product B becomes $54.79.....it needs to be somewhat "intuitive" i.e. $54.78
doesn't become $54.77 but rather $54.79 and so on.....

i am thinking I could use an ODD and some variant of ROUND function..not
sure how to combine them for the last decimal place...is this feasible?
Thanks for your help.

Regards,
Shams.