For instance, if the current workbook contains five visible sheets, one chart sheet, and two very hidden sheets, this function would return 8: 4: SHEET()Įxcel's new SHEET() function returns the sheet number of the referenced (by name) sheet. This function counts all types of visible, hidden, and very hidden sheets. Using the following form, SHEETS() returns the number of sheets in reference, where reference identifies a 3D range: Now there's a function that will do the same thing, and a bit more. VBA's Count property returns the number of sheets in the current workbook (Worksheets.Count). IFNA() lets you share specific information about errors. This function can return several error values using IFNA(), you can match the #N/A error to an invalid lookup value. Figure B shows a row of VLOOKUP() functions that return #N/A when the lookup value doesn't exist. In contrast, IFNA() considers only the #N/A error, which allows you to narrow things down. You can often get the same results using IFERROR(), but that function evaluates all error values. This function isn't superior to IFERROR(), but it is more specific about the type of error, which can lead to quicker troubleshooting. If value is an array formula, IFNA() returns an array. If an argument references an empty cell, IFNA() treats it as an empty string (""). Where value references the formula you're checking for errors and NAvalue is the value you want returned if value returns #N/A. The new IFNA() function works similarly by returning a value you specify if your formula returns the #N/A error. 2: IFNA()Įxcel 2007 added the IFERROR() function, which combines the IF() and ISERROR() functions. Figure A compares this new function to the enddate - startdate expression.ĭAYS() returns an error in row 7 because the date in column A is a string that Excel can't interpret as a valid date. Perhaps they believed it wasn't necessary, since the simple expression EndDate - StartDate will return the same result. I can't help wondering what took Microsoft so long to add the DAYS() function, which returns the number of days between two dates. But Excel 2013 has at least 10 new functions that will appeal to a wide range of users. Most of them are specialized and of use to specific users, such as analysts or engineers. You might think that Excel couldn't possibly come up with any new functions - but with every new version, we get a few more.
0 kommentar(er)
