Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If functions

	98.1 % recommend us
	More live stats...

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

Training information:

If functions

Resolved · Low Priority · Version 2003

Reply Mon 16 Nov 2009, 16:20Delegate Fiona said...

Fiona has attended:
Excel Introduction course
Excel Intermediate course

If functions

I have to analyse some quite detailed if functions in our budget spreadsheets but the ones we covered today were quite straight foward do you have any examples you could walk me through which demonstrate a more complicated level than those covered today in intermediate course?

For upcoming training course dates see: Pricing & availability

Reply Wed 18 Nov 2009, 15:18Trainer Simon said...

RE: if functions

Hi Fiona,

Thank you for your question.

Here is an example of a nested function:

=if(iserror(vlookup(a20,b1:f8,2,false),"Value not on list",vlookup(a20,b1:f8,2,false))

This nested function displays a message "Value not..." if the vlookup formula results in an error(iserror).

If the result of the vlookup does not result in an error, then it will display the result of the vlookup.

I hope this answers your question.

Regards

Simon

Excel articles

· Getting To Grips With Gantt In Excel
· Backstage Management With Excel 2010
· Customize Your Gridlines And Borders In Excel 2007
· Do Bright Sparks Use Sparklines?
· Tips To Help You Excel

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

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips