IF function - Boleen logic

[Greg]

Is there a was to use the Boleen logic within the IF
function as comibation of IF & AND for an inital
criteria. For example: IF(x<=0 and y>1, then ... etc...
Please Help!
Thanks in advance.
Greg

 

[Michael J. Malinsky]

You can incorporate the logical functions into an IF function. For example:

=IF(AND(A1=1,B1=2),TRUE,FALSE)

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[JulieD]

Hi Greg

try
=IF(AND(x<=0,y>1),true,false)

and if you want an OR statement
=IF(OR(x<=0,y>1),true,false)

cheers
JulieD

 

[Frank Kabel]

Hi
try something like
=IF(AND(X1<=0,Y1>1),1,0)

 

[Peo Sjoblom]

=IF(AND(x<=0,y>1),"Yes","No")

 

[Guest]

Thanks Julie!!!

-----Original Message-----
Hi Greg

try
=IF(AND(x<=0,y>1),true,false)

and if you want an OR statement
=IF(OR(x<=0,y>1),true,false)

cheers
JulieD




.

 

[Guest]

Thanks Peo!!!

-----Original Message-----
=IF(AND(x<=0,y>1),"Yes","No")

--

Regards,

Peo Sjoblom





.

 

[Ken Wright]

which you can also reduce to just

=AND(x<=0,y>1)

 

[Ken Wright]

Assuming you only wanted a TRUE/FALSE result that is.