Question: (0-9 pts) Write an Excel function in cell Analysis!B3, which can be copied across the row and down the column into range B3:D6, to determine
(0-9 pts) Write an Excel function in cell Analysis!B3, which can be copied across the row and down the column into range B3:D6, to determine if this airline has any flights to this destination. (Display "Available" or "Not Available"). (Hint: Use the IF() function here where the logical testreferences a cell in another worksheet and always check for if a $ is needed for the numbers in any cells used since you are copying this function down AND also check for if a $ is needed for the letters in any cells used since you are also copying this function across.). =IF(flights are available for this airline to destination cell reference in Flights worksheet, display Available, display Not Available
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
