Nested IF formula in Excel 365

[DanGreene]

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 the logic Im attempting to create and embed into one cell.

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

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

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

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

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

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

If anyone can assist, much appreciated...

[#2]

@Sergei Baklan 

I agree. I believe I was referring to the formula version that you presented that is free from CSE. ;)

Cheers!

[#3]

@Sergei Baklan 

I stepped away from my desk for a while.  Such wonderful responses.  Thank you all!

I think I am making headway.

I am placing:

=IF(G5="LOW",IF(H5="LOW","T",IF(G5="LOW",IF(H5="HIGH", IF(I5="LOW","T","NT"))))), IF(G5="MODERATE",IF(H5="LOW",IF(I5="LOW","T","NT"))), IF(G5="MODERATE",IF(H5="HIGH",IF(I5="HIGH","T","OT"))), IF(G5="HIGH",IF(H5="LOW",IF(I5="HIGH","NT","T"))), IF(G5="HIGH",IF(H5="HIGH",IF(I5="HIGH","T","OT")))

in the E5 cell to attempt to accommodate the "moderate" entries that could appear in the I5 column.  However I am getting a #VALUE! error.

I think my syntax of too many IF statements perhaps?  or is there a limit on how many you can place in one formula?

thank you

dan

[#4]

@Celia_Alves 

thank you Celia,

I haven't worked with arrays before, Ill see if I can implement them in somehow.

Ill have to think on this one for a bit.

thank you for all the wonderful help!

[#5]

@Celia_Alves 

thank you Celia!  This worked great!  I was able to populate what I needed and used the CSE to enter in the formulas!

thanks again to everyone for all their help!!

[#6]

Glad to hear you found a solution that works for you, @DanGreene! Happy that I could help. There were other valid solutions in this thread also.
Good luck with your project. :)

[#7]

@DanGreene 

Hi Dan,

If format a bit your formula it'll be

=IF(G5="LOW",
   IF(H5="LOW","T",
      IF(G5="LOW",
         IF(H5="HIGH",
            IF(I5="LOW","T","NT"))))), IF(G5="MODERATE",IF(H5="LOW",IF(I5="LOW","T","NT"))), IF(G5="MODERATE",IF(H5="HIGH",IF(I5="HIGH","T","OT"))), IF(G5="HIGH",IF(H5="LOW",IF(I5="HIGH","NT","T"))), IF(G5="HIGH",IF(H5="HIGH",IF(I5="HIGH","T","OT")))

with brackets in red you close it, all after the comma gives incorrect syntax

More correct will be

=IF(G5="LOW",
   IF(H5="LOW",
      "T",
      IF(I5="LOW","T","NT")),
   IF(G5="MODERATE",
      IF(H5="LOW",
         IF(I5="LOW","T","NT"),
         IF(I5="HIGH","T","OT")),
      IF(H5="LOW",
         IF(I5="HIGH","NT","T"),
         IF(I5="HIGH","T","OT"))
))

and in attached file

[#8]

@Sergei Baklan 

Thank you Sergei!

This works a treat!!!  I am new to excel formulas, and I have learned so much.

Thanks again!!

[#9]

@DanGreene 

Dan, good luck with Excel, that's a great tool