excel+course - IF function

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

Resolved · Low Priority · Version Standard

IF function

Shabby has attended:
Excel Advanced course

by - delegate Shabby [1 post] (2008 Jan 23 Wed, 09:47) Reply

I'd like to find out when it's appropriate to use the IF function.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: IF function

by - delegate Paul gold contributer [121 posts] (2008 Jan 23 Wed, 16:58) Reply

the IF Function is the most flexible of functions available. It can be used in some way in almost every situation

=if(isblank(A1),"",A1) is a good one

=if(and(A1=1,B1>100),"On Target","Off Target"

loads of things you can do with the if statement

· Database Tips from an Excel Training Course
· Creating Charts with Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Excel in the Home Office
· Tap the Power of Recorded Macros with MS Excel Courses

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips

Rate this page: