Hi - hoping somebody can help me with a price rounding formula which is long but must be able to be done more efficiently, the desired outcome is:
IF:
Price is:
<0.20 = $0.19
<0.30 = $0.29
<0.50 = $0.49
<0.80 = $0.79
<1.00 = $0.99
<1.30 = $1.29
<1.50 = $1.49
<1.80 = $1.79
<2.00 = $1.99
<2.50 = $2.49
<3.00 = $3.00
<3.50 = $3.49
<4.00 = $3.99
<4.50 = $4.49
<5.00 = $4.99
<6.00 = $5.99
<7.00 = $6.99
<8.00 = $7.99
<9.00 = $8.99
<10.00 = $9.99
<12.00 = $11.99
<13.00 = $12.99
<15.00 = $14.99
<17.00 = $16.99
<19.00 = $18.99
<20.00 = $19.99
<22.00 = $21.99
<25.00 = $24.99
<30.00 = $29.99
<35.00 = $34.99
<40.00 = $39.99
<45.00 = $44.99
<50.00 = $49.00
<55.00 = $54.99
<60.00 = $59.99
<65.00 = $64.99
<70.00 = $69.99
<75.00 = $74.99
<80.00 = $79.99
<90.00 = $89.99
<100.00 = $99.99
<110.00 = $109.99
<120.00 = $119.99
And through like this to
<500.00 = $499
Thereafter with no decimal points
In $50 increments i.e <750 = $749
Any assistance greatly appreciated
IF:
Price is:
<0.20 = $0.19
<0.30 = $0.29
<0.50 = $0.49
<0.80 = $0.79
<1.00 = $0.99
<1.30 = $1.29
<1.50 = $1.49
<1.80 = $1.79
<2.00 = $1.99
<2.50 = $2.49
<3.00 = $3.00
<3.50 = $3.49
<4.00 = $3.99
<4.50 = $4.49
<5.00 = $4.99
<6.00 = $5.99
<7.00 = $6.99
<8.00 = $7.99
<9.00 = $8.99
<10.00 = $9.99
<12.00 = $11.99
<13.00 = $12.99
<15.00 = $14.99
<17.00 = $16.99
<19.00 = $18.99
<20.00 = $19.99
<22.00 = $21.99
<25.00 = $24.99
<30.00 = $29.99
<35.00 = $34.99
<40.00 = $39.99
<45.00 = $44.99
<50.00 = $49.00
<55.00 = $54.99
<60.00 = $59.99
<65.00 = $64.99
<70.00 = $69.99
<75.00 = $74.99
<80.00 = $79.99
<90.00 = $89.99
<100.00 = $99.99
<110.00 = $109.99
<120.00 = $119.99
And through like this to
<500.00 = $499
Thereafter with no decimal points
In $50 increments i.e <750 = $749
Any assistance greatly appreciated