Please help me with this excel "If statement", I attached a screenshot and also paste the excel file.

We learned IF statements to let Excel use true/false scenarios to find solutions to problems for us.
You are determining the profitability for an airline based on seats sold. The following parameters exist.
# of seats sold to the public	350
# of seats on the plane (capacity)	310
# of people showing up for the flight	325
Cost per passengers on the flight	$275
Overbook fee paid to # of people who show up > capacity	$500
Ticket price	$375
Build the Model below so that the # of people who show up accurately show the Profit for each flight (your IF statements should be based off of the number in yellow).
(I should be able to change B7 and profit changes with it)
Pro Forma Model	$
Ticket revenue (# seats sold * ticket price)
Costs per passenger
Overbook costs
Profit	$0

G23 x fix L M N P Q A B D E F G . 1 J K 1 We learned IF statements to let Excel use true/false scenarios to find solutions to problems for us. 2 You are determining the profitability for an airline based on seats sold. The following parameters exist. 3 5 points 4 4. 5 # of seats sold to the public 350 6 #of seats on the plane (capacity) 310 7 # of people showing up for the flight 325 8 Cost per passengers on the flight $275 9 Overbook fee paid to # of people who show up > capacity $500 10 Ticket price $375 11 12 Build the Model below so that the # of people who show up accurately show the Profit for each flight (your IF statements should be based off of the number in yellow). 13 (1 should be able to change B7 and profit changes with it) 14 15 Pro Forma Model $ 16 Ticket revenue (# seats sold * ticket price) 17 Costs per passenger 18 Overbook costs 19 Profit $0 20 21 22 23 O 24 25 26 27 28 29 30 31 32 33 34 35 36 27 Scenario Summary 01 Q2 Q3 Q4 05 06 07 08 09 Q10 Ready Assessibility Investigate