What formula should go in cell H3 of the following spreadsheet to compute Crash Cost Per Day?
A)=(C3-E3)/(F3-D3)
B)=(F3-D3)/(C3-E3)
C)=(F3)/(C3-E3)
D)=(F3-D3)/(E3)

Question

What formula should go in cell H3 of the following spreadsheet to compute Crash Cost Per Day? 
A)=(C3-E3)/(F3-D3) 
B)=(F3-D3)/(C3-E3) 
C)=(F3)/(C3-E3) 
D)=(F3-D3)/(E3)

Quizplus · Accepted Answer

The formula to compute Crash Cost Per Day is the total cost of crashing divided by the decrease in days. This means we need to divide the difference between normal duration and crash duration by the difference in cost. Therefore, formula B is the correct choice as it divides (F3-D3) by (C3-E3).

What Formula Should Go in Cell H3 of the Following