Forum Discussion

DanGreene's avatar
DanGreene
Copper Contributor
Apr 22, 2019
Solved

Nested IF formula in Excel 365

Hello, Im having problems getting the right syntax for nexting IF statements. Basically Im comparing values already placed into cells G5, H5 and I5 to return a value placed into cell E5. This is th...
Formulas and Functions
  • Celia_Alves's avatar
    Celia_Alves
    Apr 22, 2019

    DanGreene,

    please see screenshot and file attached.

    The formula that I used is an array formula. To make the formula to work, you need to do CTRL+SHIFT+ENTER after you finish writing it or after you edit it in the formula bar. The formula will get curly brackets at the beginning and ending after you hit those three keys.

    Good luck! 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 22, 2019

DanGreene , by the way, expressions like

IF(I5="HIGH", "T", "T")

have no sense, it always returns "T" independently on what do you have in I5

 

DanGreene's avatar
DanGreene
Copper Contributor
Apr 22, 2019

Sergei,

Looking at the example:

=IF (G5="LOW" and H5="LOW"), then IF (I5="LOW", "T", IF(I5="HIGH", "T", "T"))

 

I have IF(I5="HIGH", "T", "T")) listed this way because there is a third value of "Moderate" that could be in the Cell I5 which should return a value of "T" as well.

thank you

dan

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 22, 2019

    DanGreene 

     

    Dan, sorry, but I didn't catch. The expression in second part

    =IF(I5="LOW","T",IF(I5="HIGH","T","T"))

    is equal to

    = "T"

    will it be in I5 "MODERATE", "LOW" or any other value

     

     

Resources