Excel 2007 - AND/IF

The UK's most regular instructor-led training courses.
Training information: excel+and+powerpoint+courses+uk · Excel training course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel 2007 - AND/IF

Katie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

by - delegate Katie [6 posts] (2008 Mar 12 Wed, 15:27) Reply

What does Logical Test mean?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Excel 2007 - AND/IF

by - trainer Rich platinum contributer [754 posts] (2008 Mar 20 Thu, 20:17) Reply

Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE.

· Do You Really Need Excel VBA Training?
· Compare Different MS Excel Training Methods
· Basic Excel Training
· Tips for Transitioning to Excel 2007
· How to Create Better Excel Spreadsheets: Part Three

Please browse our web site to find out more about
excel+and+powerpoint+courses+uk and other Microsoft training courses.

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)

In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips

Rate this page: