I'm trying to calculate prices for items that have various costs. Depending on what that cost is determined its multiplier. I'm hoping I can create a formula in a spreadsheet to streamline my process. Below is my logic. Everything is calculating correctly up until the third if statement. I can't figure out why
=IF(AV2<=5,AV2*4,
IF(OR(AV2>=5.01,AV2<=11),AV2*3.2,
IF(OR(AV2>=11.01,AV2<=15.5),AV2*2.8,
IF(OR(AV2>=15.51,AV2<=20.5),AV2*2.7,
IF(AV2>=20.51,AV2*2.3)))))