If statement with And issue

[tm1274]

Hello. I am trying to write an if statement including an "And" but then continue to run but I cannot seem to get it to work. I believe I need the "And" but there may be a better way. The and statement will look at 2 cells, to return blank if true like the following statement:

=IF(AND(OR(G4=B10,H4= B13),""

But if the result is false, I need to continue the statement to return a result based on the value in these same cells similar to:

IF(G4=B10,J10,IF(G4=B9,J9)

Combining the statements errors and I am not finding any examples of how to make this work. Can anyone tell me how to make this work?

 

[tm1274]

I think I just over complicated my statement. I think it should be:

=IF(AND(G4=B10,H4=B13),"",IF(G4=B10,J10,J9))

 

[6StringJazzer]

If that formula works for all combinations, then I guess you're done. If not, please describe the logic you want without using formulas to illustrate it.

This formula uses the same logic but factors out the repeated test. I have tested this to ensure it matches your formula's outcome for all combinations:

=IF(G4=B10,IF(H4=B13,"",J10),J9)

It's not "better" but some may prefer it to avoid the redundancy.

 

[tm1274]

If that formula works for all combinations, then I guess you're done. If not, please describe the logic you want without using formulas to illustrate it.

This formula uses the same logic but factors out the repeated test. I have tested this to ensure it matches your formula's outcome for all combinations:

=IF(G4=B10,IF(H4=B13,"",J10),J9)

It's not "better" but some may prefer it to avoid the redundancy.

Thanks. Your version is in my opinion better in that it is more simplified, and you are correct it worked well. Thanks for your help.