Hi All,
Just wanted some support on this one.
I created the below formula to state 3 variables depending on the outcome of my tests, "WIN", "LOSE" or "INCONCLUSIVE".
=IF((AND(AF3>Q3)),"WIN",(IF((AND(AF3<Q3)),"LOSE",(IF((AND(AF3=Q3)),"INCONCLUSIVE")))))
However I wanted to amend it so that if cell "AF3" was blank the formula would pull back "-" can anyone help me?
I tried the below but excel didn't seem to like this.
=IF((AND(AF3>Q3)),"WIN",(IF((AND(AF3<Q3)),"LOSE",(IF((AND(AF3=Q3)),"INCONCLUSIVE",(IF((AND(ISBLANK(AF3,"-")))))))
Bookmarks