If Then Help

[nabanco]

Hi, how would I say:

if cell e1 is a positive number, then return "win". If cell e1 is a
negative number then return "looser".

Thank you

 

[Lars-Åke Aspelin]

Hi, how would I say:

if cell e1 is a positive number, then return "win". If cell e1 is a
negative number then return "looser".

Thank you

Try this formula:

=CHOOSE(SIGN(E1)+2,"looser","E1 is zero","win")

Hope this helps / Lars-Åke

 

[ryguy7272]

There are a few ways to do this. This is probably one of the easiest:
=IF(E1>0,"Win",IF(E1<0,"Looser","Value is Zero"))

 

[nabanco]

Thank you

There are a few ways to do this. This is probably one of the easiest:
=IF(E1>0,"Win",IF(E1<0,"Looser","Value is Zero"))