Dominique has attended:
Excel Intermediate course
Excel Advanced course
If statement
How do I do nested if statements?
RE: If statement
Hi Dominique,
nested if statements are quite useful at times. you can only nest a maximum of 7 ifs together but it's done a bit like this.
=if(A1=1,"A",if(A1=2,"B",if(A1=3,"C")))
note that you are to put one close bracket for every open bracket.
hope this helps
Paul