« Information Functions Week (2 of 3) | Text Cases Can be Changed; Before Changing UnderPants » |
Information Functions Week (1 of 3)
FormulasHi there,
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:
- CELL
- ERROR.TYPE
- INFO
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISREF
- ISTEXT
- N
- NA
- 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:
Be Simple and Be Strong like IFERROR
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments