If Statement Help
I have a column with 6 options and I am trying to create a statement in another column that says:
=IF((Stage1) = "Opportunity", "d73ba1f291ba435e9480a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9c51b440fbbf0673174c348733")
I have 6 total stages but can't seem to get this to work. Any advice?
Geneva
Comments

You are actually pretty close. You don't need to put Stage1 in parenthesis, and you need to use extra parenthesis on the end for each additional IF statement. I also suggest using @row instead of the actual row number.
Try this:
=IF(Stage@row = "Opportunity", "d73ba1f291ba435e9480a2ccf08b36aa", IF(Stage@row = "Contact", "0137cc9c51b440fbbf0673174c348733"))
Keep going with that pattern, and you should have one ) at the end for every IF statement you use. In the example above there are 2 IF statements, so there are 2 ). If you have 6 IF statements, then you will have 6 ) at the end.
=IF(....., ......., IF(....., ....., IF(....., ....., IF(....., ....., IF(....., ....., IF(....., .....))))))

That did the trick. Thank you so much!!
Help Article Resources
Categories
Check out the Formula Handbook template!