110k views
2 votes
Cell A5 on an Excel worksheet contains a formula that calculates the percent change between the current price and the purchase price of a stock. An IF function is being used to evaluate the output in cell A5. If the value in cell A5 is greater than or equal to 3%, the output of the function should be the word OK. Otherwise, the output of the function should be the word WATCH.

In the space provided, define the logical_test argument for this IF function.___________________

User Kraysak
by
8.2k points

2 Answers

6 votes

Final answer:

The logical_test argument for the IF function in Excel would be 'A5 >= 0.03', checking if the percent change in cell A5 is greater than or equal to 3%, and give the outputs "OK" if true, and "WATCH" if false.

Step-by-step explanation:

The logical_test argument for the IF function that evaluates the percent change of a stock price in Cell A5 is A5 >= 0.03. This logical_test checks if the value in cell A5 is at least 3%, which means a 3% increase or more from the purchase price. If this condition is true, the function will output the text "OK"; if false, it will output "WATCH". Therefore, the complete IF function in Excel would look something like =IF(A5 >= 0.03, "OK", "WATCH").

User Frank Visaggio
by
8.3k points
7 votes

Final answer:

The logical_test for the IF function in Excel to check if the stock percent change in cell A5 is 3% or higher is 'A5 >= 0.03'. If true, it outputs 'OK'; otherwise, it outputs 'WATCH'.

Step-by-step explanation:

The logical_test argument for this IF function should determine if the percent change in stock price, calculated in cell A5, is greater than or equal to 3%. You would use the following logical_test in the IF function: A5 >= 0.03. In this case, the percent change is being compared to 0.03 (which is the decimal representation of 3%) to see if it meets the condition for being greater than or equal to 3%.

If the condition is true (i.e., the value in A5 is greater than or equal to 0.03), the function will result in "OK". If the condition is false (i.e., the value is less than 0.03), the function will result in "WATCH".

User Surfmuggle
by
8.3k points