Answer:
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.
