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

On Fri, 8 Jan 2010 12:48:01 -0800, nabanco
wrote:

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

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



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"nabanco" wrote:

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

Thank you

"ryguy7272" wrote:

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



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"nabanco" wrote:

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