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! 

DanGreene's avatar
DanGreene
Copper Contributor
Apr 22, 2019

SergeiBaklan

Sergei,

thank you for the reply.  Yes this is true.  In my analysis of data I collected thru employee surveys, I can distill the data given back into either T, OT or NT to populate the cell E5.   Depending on what values are placed into G5, H5, or I5, the outcome may indeed show the value of "T" for both.  These are types of training that my department will need to implement according to those values. 

I see your point though, I could rewrite the formula on those that have the same "training" value to simplify.

Twifoo's avatar
Twifoo
Silver Contributor
Apr 22, 2019
Succinctly, what conditions must be fulfilled for the required formula to return each of the possible results? If you cannot answer this question, I am sorry to inform you that you cannot also expect an answer.

Resources