If Formula

03/21/18 Edited 12/09/19

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!

Popular Tags:

Comments

  • This work for you?

     

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

     

  • All:

    Figured out the formula. No need to reply.

    Thanks

     

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

     

Sign In or Register to comment.