If, And, Or Formula

[Eden397]

Here is my equation:

IF(OR(AND(I3="DG F",I3="DG M"),AND(H3=1,D3="UNK"),ReqPO!AH3,9999),ReqPO!AH3)

I want to make this statement in the cell K3:

If (I3="DG F" or "DG M" ) and D3="UNK" and H3=0 then I want 9999 in K3.
However if there is a 1 in H3, then I need the ReqPO!AH3 number in K3.
Finally, if D3 = "N/A', then I want a blank cell for K3.

 

[Gary Brown]

=IF(ISNA(D3),"",IF(AND(OR(I3="DG F",I3="DG
M"),D3="UNK",H3=0),999,IF(H3=1,ReqPO!AH3,"unknown")))
- You left out what happens if NONE of the conditions are met, so I put
"unknown" in that part of the formula.
- Another unknown in your question is whether "N/A' is text that you put in
or is a calculation from a formula. If it's text, change the above formula
to...
=IF(D3="N/A","",IF(AND(OR(I3="DG F",I3="DG
M"),D3="UNK",H3=0),999,IF(H3=1,ReqPO!AH3,"unknown")))

 

[Eden397]

That is getting closer but I only want a blank cell if D3=N/A and I3 is
either DG F or DG M.