exceltoxl.com

Hi there,

  Share on Facebook 

Let us celebrate the Information Functions Week from today 9th of Nov, 2013 till next 13th of Nov, 2013. Have a great Information Functions Week and happy learning. This complete week we will learn about the topics mentioned below: 

• Where are these functions located in Excel?
   
• How many Information Functions are available in Excel?
   
• Explain the purpose of each Function?
    

WHERE ARE THESE FUNCTIONS LOCATED IN EXCEL?

...

These functions are located under MORE FUNCTIONS in FORMULAS tab.

HOW MANY INFORMATION FUNCTIONS ARE AVAILABLE IN EXCEL?

Do you know how many information functions available in Excel? Worry not, its 17 functions. They are as follows:

1. CELL
2. ERROR.TYPE
3. INFO
4. ISBLANK
5. ISERR
6. ISERROR 
7. ISEVEN
8. ISLOGICAL
9. ISNA
10. ISNONTEXT
11. ISNUMBER
12. ISODD
13. ISREF
14. ISTEXT
15. N
16. NA
17. TYPE

Out of 17 there are few functions which are usefull on day to day basis. Let's discuss on each function in the comming posts.

DID YOU WORK ON INFORMATION FUNCTIONS?

Have you used I F's in your work. Did you find different experiences using those functions. Please use this space to share your valuable experiences, achivements, successes in the below comment section.

If you find this topic interesting then please do share it on your social networking sites by clicking on the icons placed around the blog.

If you want to support me then REGISTER here for free and you can receive all latest updates from exceltoxl to your registered e-mail.

SOME IMPORTANT LINKS:

Excel Array's Week

Be Simple and Be Strong like IFERROR

Crack Formula Errors

Formulas Cheat Sheet

Thanks,