Eric works for an airline, and he needs to calculate the weight of passengers and luggage before takeoff. The number of passengers is in cell A1. The airline uses an average weight of 180 pounds per person, so Eric enters 180 in cell A2. The weight of the checked luggage is entered in cell A3. Each passenger is alloted 10 pounds for carry-on luggage, so he enters 10 in cell A4. Which formula should Eric use?
he wants to calculate weight of passengers and luggage total weight of passengers = (number of passengers)(avg. weight of passengers) weight of carry-on luggage = (number of passengers)(carry-on luggage weight per person) weight of checked luggage = (number of passengers)(checked luggage weight per person) and the entire weight is the sum of these three quantitites apply this logic to create a formula with your excel cells
Join our real-time social learning platform and learn together with your friends!