Question

Miranda has used a conditional formula to indicate if it's time to order more items. For the produce items, she has a formula set up in column D to have the word "No" appear if there are 15 or more items, and the word "Yes" to appear if there are less than 15 items. What is the formula that Miranda used in cell D9?

=?

Please answer quickly! ^‿^

Answer 1

According to the given scenario, we need to use both “IF” conditional statement and we require to use the built-in function called “Count()”.

The “Count()” accepts an argument which is list of range where it “counts the number of values”. This value is passed to the” if” condition to check whether it has reached the value of 15. If it is greater than 15 then we print “Yes” using true statement and “No” using false statement block.

Since the range of cell is not provided, the below formula has a text called “range”.

D9 = If(count(range)>15, “Yes”, “No”)