can someone help me with a formula....
 

What I want to achieve is:

IF text in cell D says either '2 yearly' or '5 yearly'
AND
Cell A contains any number other than 0
then
insert Text: 'IN' into cell E.
otherwise
insert Text 'OUT' into Cell E.


thanks in anticipation...
SS

try using AND and OR. Not tested.
if(and(or(d1="2 yearly",d1="5 yearly")<0),"in","out")


--
Don Guillett
SalesAid Software

"simon" wrote in message
...
What I want to achieve is:

IF text in cell D says either '2 yearly' or '5 yearly'
AND
Cell A contains any number other than 0
then
insert Text: 'IN' into cell E.
otherwise
insert Text 'OUT' into Cell E.


thanks in anticipation...
SS

One way:

E1: =IF(AND(OR(D1="2 yearly",D1="5 yearly"),A1<0),"IN","OUT")



In article ,
"simon" wrote:

What I want to achieve is:

IF text in cell D says either '2 yearly' or '5 yearly'
AND
Cell A contains any number other than 0
then
insert Text: 'IN' into cell E.
otherwise
insert Text 'OUT' into Cell E.


thanks in anticipation...
SS

I think this will work..
=IF(AND(OR(D1="2 YEARLY",D1="5 YEARLY"),A10),"IN","OUT")

"simon" wrote:

What I want to achieve is:

IF text in cell D says either '2 yearly' or '5 yearly'
AND
Cell A contains any number other than 0
then
insert Text: 'IN' into cell E.
otherwise
insert Text 'OUT' into Cell E.


thanks in anticipation...
SS

How about:
=IF(AND(A1<0,OR(D1="2 yearly",D1="5 yearly")),"IN","OUT")
Copy down as needed.

If your cells in D actually contain '2 yearly' instead of 2 yearly, you will
need to add the single quotes to this formula.

tj

"simon" wrote:

What I want to achieve is:

IF text in cell D says either '2 yearly' or '5 yearly'
AND
Cell A contains any number other than 0
then
insert Text: 'IN' into cell E.
otherwise
insert Text 'OUT' into Cell E.


thanks in anticipation...
SS

Cheers...
plenty for me to go at there....

if(and(or(d1="2 yearly",d1="5 yearly")<0),"in","out")
if(and(or(d1="2 yearly",d1="5 yearly")a1<0),"in","out")




--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
try using AND and OR. Not tested.
if(and(or(d1="2 yearly",d1="5 yearly")<0),"in","out")


--
Don Guillett
SalesAid Software

"simon" wrote in message
...
What I want to achieve is:

IF text in cell D says either '2 yearly' or '5 yearly'
AND
Cell A contains any number other than 0
then
insert Text: 'IN' into cell E.
otherwise
insert Text 'OUT' into Cell E.


thanks in anticipation...
SS