ISBLANK - Hmmmmmmm

[longie1985]

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

[Kramxel]

you're quite close, you just needed to re-order the if statements
=IF(ISBLANK(AF3),"-",IF((AND(AF3>Q3)),"WIN",(IF((AND(AF3<Q3)),"LOSE",(IF((AND(AF3=Q3)),"INCONCLUSIVE"))))))

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!

No help to be offered, please, until the OP complies with this request.

[longie1985]

you're quite close, you just needed to re-order the if statements
=if(isblank(af3),"-",if((and(af3>q3)),"win",(if((and(af3<q3)),"lose",(if((and(af3=q3)),"inconclusive"))))))

thanks! It worked

[AliGW]

Longie - please note that thread titles like this one are not acceptable - see the forum rules before you post again.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.