Question to all the Excel Experts. I am making a spreadsheet with a pricing structure for my company. The price depends on 2 factors quantity(3 levels of quantities) and price(2 levels). All together there are 6 different options I.E. If the price is less than 1 dollar and the quantity is 500 than the markup is this.
I used a IF(AND Function 6 times. Is there a better way?
This was Mine:
=IF(AND(A2>=500,B2<=1),B2*1.05,IF(AND(A2>=300,B2<=1),B2*1.10,IF(AND(A2>=100,B2<=1),B2*1.15,IF(AND(A2>=500,B2>1),B2*1.04,IF(AND(A2>=300,B2>1),B2*1.08,IF(AND(A2>=100,B2>1),B2*1.13," "))))))