Bruce,
Major adjustments
=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)),IF(ABS(RIGHT(A3*100,1)-5)<ABS(RIGHT(A3*100,1)+10-5),(INT(A3*10)+0.5)/10,(INT(A3*10-1)+0.5)/10),IF(ABS(RIGHT(A3*100,1)-9)<ABS(RIGHT(A3*100,1)+10-9),(INT(A3*10)+0.9)/10,(INT(A3*10-1)+0.9)/10))
--
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