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

=IF(A20,"Active",IF(A2<0,"Inactive","Status undefined"))
--
David Biddulph

"Gmata" wrote in message
...
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

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

regards
FSt1

"Gmata" wrote:

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

=IF(A20,"Active","Inactive")

--
---
HTH

Bob


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



"Gmata" wrote in message
...
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

One way:

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

--
Biff
Microsoft Excel MVP


"Gmata" wrote in message
...
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

And if price is exactly 0?


Gord Dibben MS Excel MVP

On Sat, 2 Feb 2008 14:48:00 -0800, Gmata
wrote:

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