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

Urijah Hayden

Biology

26 November, 16:48

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?

Anne Durham · 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