SHOWS EXCEL WORK PLEASE

Northwest Airlines gives a discount of 10% on all their unsold tickets if the number of seats sold is less than 83% of the seats available. On the other hand if the number of seats sold in more than 89% of the seats available, there will be a surcharge of 15% on
the remaining tickets. Use Logical If to compute any discount or surcharge of these flights (15 marks)
Flight No	Current Price	No. of seats Available	No. of seats Sold	Discount	Surcharge	New price
NW 005	125	350	301
NW 021	380	250	221
NW 037	1500	75	68
NW 053	875	180	145
NW 069	530	200	153
NW 085	2000	50	39