if with two conditions

[brainey2]

how do you put two different conditions within an if statement. Logically it would read IF(x>5 and y>6, TRUE), but this method does not work.

[EdMac]

Hi

if(and(x>5,y>6),true,false)

Ed

[svaiskau]

Hi

if(and(x>5,y>6),true,false)

Ed

Quoted for truth

[brainey2]

Ok, I have this function, =OFFSET(B369:B382,MATCH(MIN(IF(C369:C382>=J37,A369:A382,"")),IF(C369:C382>=J37,A369:A382,""),0)-1,0). Instead of it saying C369:C382>=J37, I want those two parts that say that to basically say that and D369:D382>=K37. Both of these conditions have to be true I'm just confused on how to get the and part in this function correctly.

[Dav]

Or if all you want to return is true or false

=and(x>5,y>6)

no need for the if

Regards

Dav

[brainey2]

Ok, I have this function, =OFFSET(B369:B382,MATCH(MIN(IF(C369:C382>=J37,A369 :A382,"")),IF(C369:C382>=J37,A369:A382,""),0)-1,0). Instead of it saying C369:C382>=J37, I want those two parts that say that to basically say that and D369:D382>=K37. Both of these conditions have to be true I'm just confused on how to get the and part in this function correctly.
Reply With Quote