IF OR Function

[TexasCPA]

=IF((B23=1.2,H23>0,"CR"),IF(B23=1.2,H23<0,"CD"))

In Cell L23: I want CR or CD

The formula says to me, If B23=1.2 and the value in H23 is > 0..00, the value in L23 should be “CR" and vice-versa.

The formula does not work. Please correct the formula

Thanks

 

[dreid1011]

The logic you are looking for is this:

=IF( logic question, true result, false result)

To perform AND / OR operations, you use these within the logic portion:

AND(A1=1, A2=0)

OR(A1=1, A1=0)

Your formula should look something like this:

=IF(AND(B23=1.2,H23>0),"CR",IF(AND(B23=1.2,H23<0),"CD",""))

Logic question 1
True result 1
Logic question 2 - note logic question 2 is within the FALSE result of the first IF function.
True result 2
False result 2

You are also trying to put the result for each logic question within the logic question itself instead of in the TRUE/FALSE result sections.

 

[TexasCPA]

The logic you are looking for is this:

=IF( logic question, true result, false result)

To perform AND / OR operations, you use these within the logic portion:

AND(A1=1, A2=0)

OR(A1=1, A1=0)

Your formula should look something like this:

=IF(AND(B23=1.2,H23>0),"CR",IF(AND(B23=1.2,H23<0),"CD",""))

Logic question 1
True result 1
Logic question 2 - note logic question 2 is within the FALSE result of the first IF function.
True result 2
False result 2

You are also trying to put the result for each logic question within the logic question itself instead of in the TRUE/FALSE result sections.

Thanks for your help-that resovlved my issue. Happy Thanksgiving from Texas

 

[dreid1011]

You're welcome, and happy to help.

 

[Scott Huish]

I think you can do that with one OR:

=IF(OR(B23<>1.2,H23=0),"",IF(H23>0,"CR","CD"))

 

[Cubist]

Don't think you need OR.

=IF(B23=1.2,IF(H23>0,"CR","CD"),"")

 

[Scott Huish]

Don't think you need OR.

=IF(B23=1.2,IF(H23>0,"CR","CD"),"")

That won't work if B23 is 1.2 and H23 is 0.