how to do nested ifs?...

[konijay]

so..I can create a column "if [alpha]="A" then "Hi" else "Bye"" but

what if I want to do a nested ifs like if([alpha]="A","Hi",if([alpha]="B","Hello","Bye"))

thank you

 

[Ken Puls]

Similar concept, although I sometimes find it helps to wrap the nested if in parenthesis:

[B]if [alpha]="A" then "Hi" else (if [alpha]="B" then "Hello" else "Bye")[/B][B]

[/B]

 

[konijay]

thank you sir!

You should come up with a PQ formula book...we need PQ formulas that can relate to Excel formulas...

 

[Ken Puls]

Well... M is for Data Monkey already covers the following conversions:

• LEFT, RIGHT, MID, LEN, FIND (Chapter 17)
• IF, IFERROR (Chapter 18)
• VLOOKUP, SWITCH (Chapter 22)
• A wide variety of date function equivalents (Chapter 24)

So I guess the question I'd have to ask is... which are missing? Which ones do you feel need coverage?