Rounding Formula to nearest .45 and .95

[k10weber]

Hi,
We have a pricing strategy that we want all rounded to the nearest .95 or .45 if under 500. If over 500 goes to the even dollar. If within 4.00 of a hundred, gets rounded to 99.
Examples:
498.00 goes to 499.95
149.00 goes to 148.95
150.25 goes to 150.45

Is there a way to do this, or at least part of it? I know the even dollar over 500 formula.

 

[XlsXprt]

How about this?

The formula in D3 is:
=IF(A3/100-INT(A3/100)>=0.96,ROUNDUP(A3,-1)-0.05,IF(A3-INT(A3)=0,A3-0.05,IF(A3-INT(A3)>=0.46,0.95,0.45)+INT(A3)))

 

[k10weber]

That's perfect. Thanks so much!