If Statement Help

ggross

I have a column with 6 options and I am trying to create a statement in another column that says: 

=IF((Stage1) = "Opportunity", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9c-51b4-40fb-bf06-73174c348733")

I have 6 total stages but can't seem to get this to work.  Any advice?

Geneva

Paul Newcome

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", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage@row = "Contact", "0137cc9c-51b4-40fb-bf06-73174c348733"))

 

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(....., .....))))))

ggross

That did the trick.  Thank you so much!!