2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to add multiple conditions to IF function?

I am working on an assignment for an information systems class and am very confused with this instruction. It reads:

“a. In cell H5, insert a formula using an IF function. The first condition tests whether the pledge amount (cell D5) is greater than or equal to 5000 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 D5) is greater than or equal to 2000 and displays the level as “Silver” if the condition is true.

c. Display the level as “Bronze” for any other pledge amount.

d. Use the Fill Handle to fill the range H6:H17 with the formula in cell H5, filling the range without formatting.”

I believe I know how to do a. and d. but I cannot figure out the other two.

I can’t seem to be able to add more than one condition using the IF function, and I can’t use the same function twice on the same cell.

I attempted to search for solutions in the module and found nothing. During other attempts to search, I found something called a “nested IF,” which I tried a few different ways and couldn’t seem to get right.

Could someone please show me how to correctly input this? Any assistance is appreciated.

submitted by /u/fungalMomence
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#enterprise-level spreadsheet solutions
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#AI-driven spreadsheet solutions
#no-code spreadsheet solutions
#IF function
#pledge amount
#condition
#Gold
#Silver
#Bronze
#nested IF
#formula
#cell D5
#cell H5