Forum Discussion
Solved
Excel if/then formulas
I have a situation i cannot find a formula or help for. Here goes: If cell N2=S, then run P2-H2, and if that value is >14, Return "N" If cell N2=E, the. Run P2-H2, and if that value is >3,...
=IF(OR(AND(N2="S",P2-H2>14),AND(N2="E",P2-H2>3)),"N",IF(OR(AND(N2="S",P2-H2<=14),AND(N2="E",P2-H2<=3)),"Y",""))You can try this nested IF formula.
=IF(OR(AND(N2="S",P2-H2>14),AND(N2="E",P2-H2>3)),"N",IF(OR(AND(N2="S",P2-H2<=14),AND(N2="E",P2-H2<=3)),"Y",""))You can try this nested IF formula.
One more question....
Hope so i wrote a formula for of any cells Z3-AE3 are N, return N in cell AF3??
- This one is not working. Where did the 6 come from in your equation?
It worked! Thank you! I was 3 days trying to figure that out! I may have another one at o work through this excel!!!
