Excel

Resolved · Low Priority · Version 2003

Excel

Conor has attended:
Excel Advanced course

by - delegate Conor [2 posts] (2008 Jun 26 Thu, 16:56) Reply

why can you only use a limited no. of "if's" in a forumla?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: excel

by - trainer David gold contributer [416 posts] (2008 Jul 8 Tue, 10:53) Reply

Conor

This is the result of a programming limitation, and cannot be overwritten, leaving a maximum of 7 sub if expressions in an If statement.

regards

Best Team

· Benefits of learning about Excel charts
· How to check for and reduce errors in Microsoft Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Excel and Inventory Management

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips

Rate this page: