Question

The specifications for a product you are developing require that the cross-section area cannot be greater than 12 in2. You have summarized the dimensions of 5 prototypes you have made. Column D has an equation to determine if your product meets spcifications. It indicates that only specimen

Answer 1

=IF(B3*C3<=12, "Yes", "No")

Step-by-step explanation:

Image for the question is attached here

Complete question

The specifications for a product you are developing require that the cross-section area cannot be greater than 12 in2. You have summarized the dimensions of 5 prototypes you have made. Column D has an equation to determine if your product meets specifications. It indicates that only specimen #5 meets the specifications.

What is the equation in cell D3?

Solution

As we can see in the table,

For all those tests in which the product of corresponding cell values in column B and C under the heads vertical and horizontal dimension respectively is less than
`12` square inch the column D values is "No". That is it does not meet the specification. Here specification is "cross-section area cannot be greater than 12 in2"

Here IF function is used for conditional formatting.

Thus, the formula in the cell must be

=IF(B3*C3<=12, "Yes", "No")