Hi,
My excel skills are at a beginner level. I am trying to write a nested if and Function but excel wont accept the formula I have written. Please review it for me as I can not seem to find the error. The code is pasted below:
=IF(AND(B7="SHORT",E5="SHORT"), "RANGE",
IF(AND(B7="SHORT",E5="LONG"), "SHORT”,
IF(AND(B7="LONG",E5="SHORT"), "LONG”,
IF(AND(B7="SHORT",E5="NEUTRAL"), "SHORT”,
IF(AND(B7="NEUTRAL",E5="SHORT"), "LONG”,
IF(AND(B7="NEUTRAL",E5="LONG"), "SHORT”,
IF(AND(B7="LONG",E5="NEUTRAL"), "LONG”,
IF(AND(B7="SHORT",E5="NEUTRAL"), "SHORT”,
""))))))))
Thank you in advance.
Bookmarks