Forum Discussion
Solved
Nested IF formula
Hello everyone, I am currently working on a prospect excel sheet and I would like to create an IF formula which gives a certain number depend on what is in the cell. For now, I only managed c...
In my file formula works
All Directors 2 =SUM(COUNTIF(A10,{"*Engineer*","*Expert*"}),COUNTIF(A10,{"*Director*","*Manager*"})*2) Our Managers 2 =SUM(COUNTIF(A11,{"*Engineer*","*Expert*"}),COUNTIF(A11,{"*Director*","*Manager*"})*2)did you check it?
perhaps you could attach small sample with your formulas
Hello Sergei,
For some weird reason it works now :)
I just have one more question, how would you do if I want the cell to show 3 if none of the words I want appear in the chosen cell ?
Thank you very much !
Alexandre,
That could be
=CHOOSE(SUM(COUNTIF(A1,{"*Engineer*","*Expert*"}),COUNTIF(A1,{"*Director*","*Manager*"})*2)+1,3,1,2)
and attached
You are welcome, have a good time
Hello Sergei,
It works perfectly !
I cannot thank you enough !
Thank you for your time and patience !
Good afternoon to you :)