98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » If functions
If functions
Resolved · Low Priority · Version 2003
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?
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |
