Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - If statement
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft excel training - If statement
Resolved · Low Priority · Version Standard
Reply Fri 28 Sep 2007, 16:17Delegate Dominique said...
Dominique has attended:
Excel Intermediate course
Excel Advanced course
If statement
How do I do nested if statements?
For upcoming training course dates see: Pricing & availability
Reply Fri 28 Sep 2007, 21:44Delegate Paul said...
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
|