Question: a . In cell H 5 , insert a formula using an IF function. The first condition tests whether the pledge amount ( cell D
a In cell H insert a formula using an IF function. The first condition tests whether the pledge amount cell D is greater than or equal to and displays the level as "Gold" if the condition is true.
b The next condition uses another IF function to test whether the pledge amount cell D is greater than or equal to and displays the level as "Silver" if the condition is true.
c Display the level as "Bronze" for any other pledge amount.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
