Tuesday, 7 July 2015

Excel Tips - Tip 2 (Using IS formula)

Hello,

Thanks for the appreciation you have given to me on my first excel tips.

Here is the Second day Tip for you. Hope this help you.

Using IS Formulae is very easy and effective.


IS Formulae Family
ISBLANK() ; ISERROR() ; ISNA() ; ISNUMBER() ; ISEVEN() ; ISODD() ; ISTEXT() ; ISNONTEXT()

How it help us :
Check the specified values and give us TRUE or FALSE depending on Outcome

How to use it :
= ISBLANK() ; ISERROR() ; ISNA() ; ISNUMBER() ; ISEVEN() ; ISODD() ; ISTEXT() ; ISNONTEXT()


Here are some Examples for the same.



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
+91-9045773456


No comments:

Post a Comment