Forum Discussion
Solved
Nested if and funtions
Hi first of all my name is Rui and i'm here with a problem that i could not solve . i would like to do an instruction to verify the text inside 2 cells and if the text assume 2 descriptions then i c...
=IF(AND(D3="LONG";E3="Positive"),"+",IF(AND(D3="SHORT";E3="Positive"),"+","Neutral"))
=SE(E(D3="LONG";E3="Positive");"+"; SE(E(D3="SHORT";E3="Positive");"+";"Neutral"))
=IF(AND(D3="LONG";E3="Positive"),"+",IF(AND(D3="SHORT";E3="Positive"),"+","Neutral"))
=SE(E(D3="LONG";E3="Positive");"+";
SE(E(D3="SHORT";E3="Positive");"+";"Neutral"))
Thank you Juliano it works fine and as supposed to. i look to your expression and i was trying to follow the logic value plus value if true , value if false in every separated if and that way seems that does not work. only works like you send me where the value if false output as the second IF connected. Thanks i was getting furious with the code :).
- Any time. Just remember to flag it as solved and smash the like button.
