Need help with formula

[Gmata]

I am trying to create a formula.
Basicly what i need is this

in one column i have prices and the other column i have status.

If price is greater than 0.00 the status is Active
If prices is less than 0 the status is Inactive.

Thanks

 

[David Biddulph]

=IF(A2>0,"Active",IF(A2<0,"Inactive","Status undefined"))

 

[FSt1]

hi.
price in A column, status in B column and in a third column....
=if(A1>0,"Active","inactive")

regards
FSt1

 

[Bob Phillips]

=IF(A2>0,"Active","Inactive")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[T. Valko]

One way:

=CHOOSE(SIGN(A1)+2,"Inactive","","Active")

 

[Gord Dibben]

And if price is exactly 0?


Gord Dibben MS Excel MVP