If Formula

Tony Barthelemy · 03/21/18

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 · 03/21/18

This work for you?

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

Tony Barthelemy · 03/21/18

All:

Figured out the formula. No need to reply.

Thanks

Tony Barthelemy · 03/21/18

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"))))

If Formula

Comments

Help Article Resources

Categories