Forum Discussion

Usfhotchris's avatar
Usfhotchris
Copper Contributor
Jan 18, 2023
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,...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jan 18, 2023

    Usfhotchris 

    =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.

     

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 19, 2023

Usfhotchris 

=IF(COUNTIF(Z3:AE3,"Y")=6,"Y",IF(COUNTIF(Z3:AE3,"N")>=1,"N",""))

Maybe with this formula. It returns "Y" if all 6 cells Z3-AE3 contain "Y" and it returns "N" if at least one the cells Z3-AE3 contains "N".

Usfhotchris's avatar
Usfhotchris
Copper Contributor
Jan 19, 2023
I'm def. Closer, and it's my fault, as i told you wrong. The cells can contain Y OR NA to show overall a Y.

Resources