If Then Help

  • Thread starter Thread starter nabanco
  • Start date Start date
N

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
 
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
Click to expand...

Try this formula:

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

Hope this helps / Lars-Åke
 
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"))
 
Back
Top