Bruce,

You can use the following formula:

=IF(MIN(ABS(RIGHT(A3*100,1)-5),ABS(RIGHT(A3*100,1)+10-5))<MIN(ABS(RIGHT(A3*100,1)-9),ABS(RIGHT(A3*100,1)+10-9)),(INT(A3*10)+0.5)/10,(INT(A3*10)+0.9)/10)

Replace cell A3 with the cell containing the 2 DIGIT number. This also
loses precision as the numbers 2 & 7 are equidistant from the 5 and 9.
--
Regards,
Eddie
http://www.HelpExcel.com


"Bruce" wrote:

How can I round prices to the nearest 0.05 or 0.09?

Eg 1
5.01 to 4.99
Eg 2
4.44 to 4.45

Regards,

Bruce