Nested IF functions are one of those Excel hurdles that can make a straightforward assignment feel like a logic puzzle written in a foreign language. The confusion here is understandable: the instructions ask for multiple conditions in a single cell, but the basic IF function only handles one test at a time. The solution, as you already suspected, is nesting, placing one IF function inside another. But getting the syntax right requires seeing the structure clearly.
Here is the formula that belongs in cell H5: `=IF(D5>=5000,"Gold",IF(D5>=2000,"Silver","Bronze"))`. Read it from left to right. The outer IF checks the first condition: is the pledge amount $5,000 or more? If true, it returns "Gold" and stops. If false, it moves to the second IF, which checks whether the amount is $2,000 or more. If that is true, it returns "Silver". If that is also false, the final value "Bronze" appears as the catch-all. The key is that the second IF is placed exactly where you would normally put the "value if false" argument of the first IF. Excel evaluates the outermost condition first, then works its way inward until it finds a true result or reaches the final default.
What makes this tricky is that nested IFs demand a specific order. You must test the highest threshold first. If you reversed the conditions and tested for $2,000 before $5,000, a $7,000 pledge would trigger "Silver" instead of "Gold" because the first true condition would stop the function. This is not a bug; it is how logical precedence works in any programming context. Once you understand that order matters more than the number of conditions, nested IFs become a tool you can adapt confidently.
After you enter the formula in H5, use the Fill Handle to drag it down through H17. The cell references will adjust automatically, so each row tests its own pledge amount. That is the practical payoff: one formula, written correctly once, handles dozens or hundreds of rows without manual repetition. Your assignment is asking you to master a foundational skill that scales directly into real-world data work. The frustration you feel now is the price of learning a pattern that will save you hours later. Copy the formula above, test it against values like 5000, 2000, and 1500, and you will see the logic lock into place.