Question

In cell F15, insert a function that will automatically display the word Discontinue if the value in cell D15 is less than 1500, or the text No Change if the value in cell D15 is greater than or equal to 1500.

Answer 1

Answer:

=IF(D15<1500, "Discontinue", "No Change")

Explanation:

Assuming that this is excel, you can locate the cell F15 and input the IF function. The formula for IF function is

IF(<condition>, <action if true>, <action if false>)

So before the 1st comma, we place the condition which is D15 < 1500

In the middle, before the 2nd comma, we place the text to display if D15 is less than 1500, which is "Discontinue".

In the last place, we place the text to display if D15 is greater than or equals to 1500, which is "No Change"

So the overall formula is =IF(D15<1500, "Discontinue", "No Change")

Answer 2

The question is an illustration of the IF function in Microsoft Office Excel.

The required IF function is: =IF(D15<1500, "Discontinue", "No Change")

The syntax of an IF function in Microsoft Office Excel is:

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

From the question, we have the following parameters

• The cell to test is: cell D15
• The value to test is: 1500
• The value, if the condition is true is: "Discontinue"
• The value, if the condition is false is: "No change"

So, the logical test to test is: D15 < 1500

This gives

= IF(D15 < 1500,[value_if_true],[value_if_false])

If the condition is true, the function will return "Discontinue"

So, we have:

= IF(D15 < 1500,"Discontinue",[value_if_false])

If the condition is false, the function will return "No Change"

So, we have:

= IF(D15 < 1500,"Discontinue","No Change")

Hence, the required IF function is:

= IF(D15 < 1500,"Discontinue","No Change")

Read more about Microsoft Excel IF functions at:

https://brainly.com/question/2844263