Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started