I am a car salesman with a spreadsheet that calculates how many units I have sold and my supergross (amount of money made on each vehicle I sell). I get paid based on a chart like this. What formula do I use to figure this out? I tried a nested IF(AND) but there has to be an easier way. Just to be clear on the chart, If I sell 1-8 cars and my supergross is $2,299 or less I make $50/car. How can I calculate the amount I make on each car?
