Microsoft Office Tutorials and References
In Depth Information
Figure 15-12: Using an array formula to return only the positive values in a range.
This modified array formula, entered into range E4:E23, uses the IFERROR function to avoid the error value
The IFERROR function was introduced in Excel 2007. For compatibility with older versions, use this formula
entered in G4:G23:
Search JabSto ::

Custom Search