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?
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
