how to do nested ifs?...

K

konijay

New member
Joined
Apr 1, 2016
Messages
6
Reaction score
0
Points
0
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
 
Similar concept, although I sometimes find it helps to wrap the nested if in parenthesis:

Code: 
[B]if [alpha]="A" then "Hi" else (if [alpha]="B" then "Hello" else "Bye")[/B][B]
[/B]
 
thank you sir!

You should come up with a PQ formula book...we need PQ formulas that can relate to Excel formulas...
 
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?
 
You must log in or register to reply here.
Back
Top