If Formula

Tony Barthelemy

Good Day All:

 

I am trying to create the following Formula however I am receiving an  Incorrect Argument:

If impact is High and Influence is High, then the Classification is Key Player

My Formula: =IF(AND([Impact on Project]2 = "High", [Project Influence]2, "High", ="Key Player"))

 

All help appreciated, Thanks!

Tony Coleman

This work for you?

 

=IF(AND([Impact on Project]2 = "High", [Project Influence]2 = "High"), "Key Player")

 

Tony Barthelemy

All:

Figured out the formula. No need to reply.

Thanks

 

Tony Barthelemy

Tony:

 

I just saw your reply, thanks. I also expanded my formula:

=IF(AND([Impact on Project]2 = "High", [Project Influence]2 = "High"), "Key Player", IF(AND([Impact on Project]2 = "High", [Project Influence]2 = "Low"), "Important Player", IF(AND([Impact on Project]2 = "Low", [Project Influence]2 = "High"), "Affected Player", IF(AND([Impact on Project]2 = "Low", [Project Influence]2 = "Low"), "Potential Player"))))