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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!