Question: Need help with excel. What is the formula for the whole column for D. Rows that say Mango Air and Econ Air? Using the IF

Need help with excel. What is the formula for the whole column for D. Rows that say "Mango Air" and "Econ Air"? Using the IF function. Not sure how to get those to appear using formula/the IF function.

Projects EX-2 1 Using Functions (continued) PrjEX-2 Excel Sarah Smith FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Formatting nsert LE Conditional Arial 14 A A Genera Format as Table Delete Sort & Find & B I U Format Filter Select Cell Styles Editing Clipboard Font Alignment Celis Number Styles G15 Aereo Groupo S.A. Student's Name) Mango Air Econo Air 3 Destination Number of Flights Number of Flights Most Flights 4 Costa Rica 125 135 Econo Air 157 5 Panama 143 Mango Air 221 Mango Air 6 Mexico 235 Econo Air 7 Venezuela 93 101 Econo Air 8 Nicaragua 85 Mango Air El Salvador 137 Econo Air 10 Colombia 1057 1029 12 Minimum 235 13 Maximum 151 147 14 Average 16 Countries 17 Aereo Source Sheet BB READY 4:07 PM Media Technics

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 Databases Questions!