Forum Discussion

Monica Primus's avatar
Monica Primus
Copper Contributor
Feb 16, 2017
Solved

I need help writing a complex formula

I am new at this and am not sure how to word my question.   In my workbook titled "Menu Analysis" I have 16 colums.  I need to write a formula that will populate the 13th column with one of four te...
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 16, 2017

Monica, attached is Menu Engineering sample file, in Example tab you'll find the formula

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Feb 19, 2017

I'm not a fan of hiding answers in attached spreadsheets, so please allow me to post the approach here, where it can be read without downloading a file. 

 

 

=IF(D2="Low",IF(L2="High","Puzzle","Dog"),IF(L2="High","Star","Question Mark")

 

The first (outer) IF statement checks the value of D2. If it is "Low", then the TRUE part of the outer IF statement will be executed, which contains another IF statement that checks L2. In the same vein, when D2 is not "Low", the IF statement in the False part of the outer IF is executed.  

 

Written in pseudo-code it looks like this:

 

 

if D2 is low then
    if  L2 is high then
         "Puzzle"
    else
        "Dog"
else
    if L2 is high then
          "Star"
    else
         "Plow horse"



Resources