Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel learn london - IF statements

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel learn london - IF statements

Resolved · Low Priority · Version Standard

Reply Fri 11 Jan 2008, 15:14Delegate Nicholas said...

Nicholas has attended:
Excel Advanced course

IF statements

Is there a maximum number of IF statements you can have in a formula?

Thanks
Nick

For upcoming training course dates see: Pricing & availability

Reply Mon 14 Jan 2008, 13:45Trainer Rajeev said...

RE: IF statements

Dear Nick

Any version prior to Excel 2007 has a limit of 7 IF statements that can be used.

Excel 2007 Microsoft has increased it to 64 IF Statements.

Normally it is suggested that you use VBA coding if you have more than 7 If Statements that you wish to use in the same cell.

But there is, however, a way around using more than 7 If Statements without the knowledge of VBA by using the naming ranges.

Please post your specific question containing more than 7 If statements and I

Excel articles

· Create An Improvised Bar Chart In Excel
· How To Share Files In Excel 2010
· Interesting Lifestyle Applications for Microsoft Excel
· Creating And Importing Custom Lists In AutoFill
· Excel Offers A More Relaxing Way To Work Out

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips