=B2*LOOKUP(A2,{0,219.99,239.99,259.99,279.99,299.99,349.99},{5,5.5,6,6.5,7,7.5,8})
=IFS(B3>350,C3*8,B3>=300,C3*7.5,B3>=280,C3*7,B3>=260,C3*6.5,B3>=240,C3*6,B3>=220,C3*5.5,B3<220,C3*5)
