In cell i10, create a formula that uses the if function to determine if a packaged clothing set is overweight by checking if the shipping weight (cell i9) is greater than 40. if this condition is true, the cell should display yes, and if it is false, the cell should display no. (hint: use "yes" for the value if true, and "no" for the value if false.)

Question

Biology

Seth Barr

26 September, 03:42

In cell i10, create a formula that uses the if function to determine if a packaged clothing set is overweight by checking if the shipping weight (cell i9) is greater than 40. if this condition is true, the cell should display yes, and if it is false, the cell should display no. (hint: use "yes" for the value if true, and "no" for the value if false.)

+3

Answers (1)

Know the Answer?

Cara · Answer 1

=IF (i9 ≥ 40, "YES", "NO")

Explanation:

Here, IF is the condition

we know that,

IF (logical_test, [value_if_true], [value_if_false])

Here we are using greater than formula:

=IF (i9 ≥ 40, "YES", "NO")

It means that,

If the package is more than or equal to 40 then it will show "yes", or otherwise "no"

Here we are using yes instead of true and no instead of false