Jeff has created a table to calculate the cost of raw materials that he purchases monthly. Cell A2 shows the fixed cost of the raw material (3). Column D lists the quantity (number of units) that Jeff purchased each month. What formula can Jeff use in E2 to calculate the monthly cost of the raw material that he can copy to all the rows below?

Question

Computers & Technology

Ignacio Ho

28 June, 14:05

Jeff has created a table to calculate the cost of raw materials that he purchases monthly. Cell A2 shows the fixed cost of the raw material (3). Column D lists the quantity (number of units) that Jeff purchased each month. What formula can Jeff use in E2 to calculate the monthly cost of the raw material that he can copy to all the rows below?

+1

Answers (1)

Know the Answer?

Aliya Patton · Answer 1

=A2*D2

The above formula will allow calculation of monthly cost ofthe first raw material. This is done by Multiplying the contents of cell A2 (Column A, Row 2) and cell D2 (Column D, Row 2). Here Cell A2 contains cost of the first raw material and Cell D2 contains number of units of the raw material produced each month. After finding the monthly cost of the first raw material in this way, the monthly cost of other raw materials can simply be calculated by dragging down the formula to apply to the rows below.