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 $4000. Otherwise, the function will display a blank cell. Use Auto Fill to copy the function down, completing the data in column G.

Answer 1

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.