Grader $-$ Instructions

Excel $2$

Step

Instructions

$21$ Enter a nested function in cell G$8$ 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$.$