Sean works for a company that ships hospital equipment. He needs to calculate the weight of the items being shipped. He enters t

Question

3 years ago

12

Sean works for a company that ships hospital equipment. He needs to calculate the weight of the items being shipped. He enters t

he number of items in cell A1. The weight of each item is 180 pounds, so Sean enters 180 in cell A2. The weight of the packaging for each item also needs to be included. This weighs 10 pounds for each item, so he enters 10 in cell A3. Which formula should Eric use to calculate the total weight?

Computers and Technology

1 answer:

Anika [276] · Answer 1 · 2022-04-24T22:37:15+03:00

Answer:

= A1 * (A2 + A3)

Explanation:

In order to calculate the total weight of the equipment, he would need to first add the total weight of each item. This is done by adding the weight of the item by the weight of the packaging. Once you have this amount you can multiply this value by the total number of items being shipped and that should give you the total weight of the shipment. Using the cells, this can be calculated with the following formula in Excel...

= A1 * (A2 + A3)