BradleyS
Reputation: 215
Combining multiple IF formulas
How can I combine these two formulas, so that it looks for BOB or JOE and enters the correct answer or if neither it should just enter -?
=IF(R15="BOB","YES","-")
=IF(R15="JOE","NO","-")
Upvotes: 2
Views: 110
Answers (1)
Scott Craner
Reputation: 152450
You need to put the second in the False return of the first:
=IF(R15="BOB","YES",IF(R15="JOE","NO","-"))
Upvotes: 1
Related Questions
- Combining 6 IF formulas
- combining three "if" formulas in addition to "else" statement"
- Adding multiple if statements together
- Combining multiple IF-statements into one formula
- Combining multiple IF statements together in Google Sheets
- how to combine multiple IF in ms excel
- How to use multiple separate formulas in a single "IF" in Excel?
- Multiple excel formulas
- Multiple IF Formulas
- Combine two nested IF formulas