Multiple =IF in formula?

[frankiiie]

Hi all,
I need help creating an =IF formula as follows;
If the value is equal to or greater then 0.00 = Win, 0.00 = Square, Lower = Loss and blank if nothing is entered.

So far I have gotten up to the formula below;
=IF((A1>0.00),"Win","Loss")

So only the win and loss, would really appreciate any help.
Cheers!

 

[Joe4]

Welcome to the Board!

You can nest your IF statements, i.e.:

=IF(A1="","", IF(A1>0,"Win",IF(A1=0,"Square",IF(A1<0,"Loss","???"))))

 

[Jonmo1]

Might also try

=IF(A1="","",CHOOSE(SIGN(A1)+2,"Loss","Square","Win"))

 

[Joe4]

Jon,

You might need to add an IF piece to handle the last option he mentioned:

...and blank if nothing is entered

EDIT: I see you edited your original solution to do that. Very clever approach, by the way!

 

[Jonmo1]

EDIT: I see you edited your original solution to do that. Very clever approach, by the way!

Thanks.


P.S. I swear I added the IF before you posted that..
You sure were fast in catching that, couldnt' have been more than 30 seconds.

 

[frankiiie]

Works like a charm thank you very much. Also very impressed by the activity on this forum.
But could anyone explain the last part of the formula;
"???"

What should that do?

 

[Joe4]

But could anyone explain the last part of the formula;
"???"

I just tossed that into the "FALSE" argument of the last IF statement. If it goes through all the IF statements and doesn't find any TRUE part to match, it will print that.
I don't think that should ever come into play, but if you have something really odd in the cell, it is possible.