Ask Question
16 January, 08:17

Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than or equal to $4000. Otherwise, the function will display a blank cell. Use Auto Fill to copy the function down, completing the data in column G.

+5
Answers (1)
  1. 16 January, 08:37
    0
    IF (AND (Payment_Type = 'Credit', Amount > = 4000),'Flag')

    Explanation:

    Given

    Search criterion 1: Payment Type: Credit

    Search Criterion 2: Amount ≥

    $4000

    Given the above search criteria, the nested function is as follows;

    IF (AND (Payment_Type = 'Credit', Amount > = 4000),'Flag')

    The above statement will display the word 'Flag' without the quotes if and only if the two conditions in the brackets are satisfied

    Condition 1: Payment_Type = 'Credit'

    Here, Payment_Type is used because when naming a column, it's preferred to avoid space or blank characters.

    So, if this condition is satisfied (i. e. if payment type is credit) it checks for condition 2

    Condition 2: Amount>=4000

    This mean the amount must be at least 4000.

    Both conditions must be satisfied because of the AND clause in the statement.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than or equal to ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers