You should just be able to follow the pattern I gave you and substitute the formulas where needed, i.e. put this formula in cel B5:First of all, thank you all for the answers!
@Joe4
I made a mistake in my post, i am sorry! If B4 is between 50 and 100 then B5 is B3*B4%*1.5%, i meant the value from B4 is percent.
In B column if B4=49.9 (B4<50), then B5=B3*0.499*0.
If B4=51 then B5=B3*0.51*0.015.
If B4=101 then B5=B3*0.015
=IF(B4>100,B3*0.015,IF(B4>=50,B3*0.51*0.015,0))
=B3*0.499*0