Tuesday 14 July 2015

Excel Tips - Tip 7 (Using IFERROR() formulae)

Hello,

I hope you are finding these emails to be useful. Thanks a lot for your feedback. :)

Here is a Tip for Today.

Have you ever faced problem in handling errors in MS excel, (example : where you have to use IF() formula with the condition as a Vlookup() output.)

Here is how you can handle the errors in MS Excel using IFERROR() formula.






Note : Error evaluated by IFERROR:#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal
Excel Enthusiast
+91-9045773456







No comments:

Post a Comment