How to use excel cell function

Version in which excel CELL function can work: Excel CELL function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Starter 2010. About CELL function in excel: CELL function can be used to retrieve the information about the cell like, formatting, location, content…

Continue Reading

How to use INFO function in excel

Excel version in which INFO function can work: INFO function works in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Starter 2010. This function is not available in Excel Web App. About INFO function in excel: You can get information about current environment like current…

Continue Reading

ISERROR and IFERROR excel functions to handle error value

In Microsoft Excel, if the inputs are not valid, then the formula will show the error. This error may be like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. To avoid this error, you can use the "ISERROR" or "IFERROR" formula. "IFERROR" is simple and easy, but this function is available only in Excel 2007 and above versions.   In this post you can learn how to use these two functions to handle the error in excel formula. If you…

Continue Reading
Close Menu
×

Cart