AND shenanigans in XL2010

[MeGustaXL]

Hi there,

As usual, I'm getting in a tangle with my ORs and ANDs

The conditions I want to evaluate are of the form IF X and Y THEN A ELSE " " OR IF B AND C THEN A ELSE " "

Trying to put this into a formula keeps giving me errors, and I know it's the syntax and order of IFs ANDs and ORs, but I can't see the wood for the trees!

These two formulas work fine in separate cells, so how should I graft them together?

=IF(AND(BM3="INITIAL",BN3="FIXED"),A3," ")

=IF(AND(BM3="REVIEW",BN3="FIXED"),A3," ")


Chris

Someday I'll know what I'm donig...damn!

 

[combo]

Your statement IF X and Y THEN A ELSE " " OR IF B AND C THEN A ELSE " " is not clear.
The output of the first statement is either A (A3) or " ". The same for the second one. What do you mean by the OR in the middle?

combo

 

[MeGustaXL]

Hi combo (and Everybody)

I think that's part of my problem; I don't need the OR in the middle, it should just be two nested IFs, viz:

=IF(AND(BM3="INITIAL",BN3="FIXED"),A3,IF(AND(BM3="REVIEW",BN3="FIXED"),A3,""))

Now, IF BN3 equals "FIXED" AND BM3 equals either "INITIAL" OR "REVIEW" then it puts the value from A3, otherwise blank; which is what I wanted

Chris

Someday I'll know what I'm donig...damn!

 

[Deniall]

Your final sentence sums it up logically.[ ] So implement what it says:
[tt]=IF( AND(BN3="FIXED",OR(BM3="INITIAL",BM3="REVIEW")) , 3 , "" )[/tt]