ISERROR in Microsoft Excel

While performing some Mathematical calculation in excel many error comes as result as #DIV/0!
To hide these errors in the result use combination of IF, ISERROR and your calculation like this.

=IF(ISERROR(C4/D4),0,C4/D4)

ISNA and Vlookup in Microsoft Excel

I believe you are frequent user of Vlookup function. Have you ever send #N/A in the result.

When you apply Vlookup on lookup value is it is available in Table array corresponding result will be displayed and if it is not available in Table array an error #N/A will be returned that looks very funny in the result.
To avoid this we use combination of IF, ISNA function with Vlookup, Syntax is as following.

=IF(ISNA(VLOOKUP(C6,$F:$F,1,0)),"",VLOOKUP(C6,$F:$F,1,0))

This formula will replace all #N/A to blank. You can put your custom text or 0 in place of "".

C6 is lookup value
F:F is table array

Try it yourself.

Can any one guide me how to use calculated field in Pivot Table. I making a report in wihch i want to show sum of two fields that are present in data but i do not know how to display the sum.

Indian Cricket

Sehwag made triple century today, what do you say he will continue making it or ????

Free Microsoft Excel Training

Visit this site, it is cool, Its a free online microsoft excel tutorial, content is very practical and you can download examples in excel format as well as video examples.
http://www.exceltutorial.in