IF -VE, Short, IF +VE, Long

[Megatronv]

Hi,

In the below example, if cell A is a negative, I would like cell B to say "Short", if a positive number however, I would like it to say "Long"

Thanks

Cell A==> Cell B
-55==> Short
10==>Long
-12==> Short

[davsth]

if(a1<0,"short","long") but you have not said what happens to 0

[Greg M]

Hi there,

Try entering the following formula in cell B1 and see if it does what you need:

Please Login or Register  to view this content.

Regards,

Greg M