Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conditional Formatting Data bars Examples in Excel
  • How to Sort by Color in Excel
  • Chart Axes in Excel
  • How to calculate current stock or inventory in Excel
  • Get column name from index in Excel Table

References

  • Merge tables with VLOOKUP in Excel
  • How to get last row in numeric data in Excel
  • How to get first column number in range in Excel
  • How to use Excel MMULT Function
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation date in next 30 days
  • Excel Data validation must contain specific text
  • Excel Data validation require unique number
  • Excel Data validation don’t exceed total
  • Excel Data validation whole percentage only

Tag: ISERROR function

IS functions: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT

by

What is IS function in Excel? IS functions, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT are under the Information functions in Microsoft Excel. Each of these functions, referred to collectively as the IS functions, checks the specified value and returns TRUE or FALSE depending on the outcome. For example, the ISBLANK function returns the logical value TRUE if the …

Continue Reading

Count Errors in Excel

by

IF function and ISERROR function are used to check for an error in Excel. This example shows you how to create an array formula that counts the number of errors in a range. 1. We use the IF function and the ISERROR function to check for an error in the record below: Explanation: the IF function returns 1, if an …

Continue Reading

Count cells that contain errors in Excel

by

This tutorial shows how to Count cells that contain errors in Excel using the example below; Formula =SUMPRODUCT(–ISERR(range)) Explanation To count cells that contain errors, you can use the ISERR function, wrapped in the SUMPRODUCT function.  In the example shown, E5 cell contains this formula: =SUMPRODUCT(–ISERROR(B5:B9)) How this formula works SUMPRODUCT accepts one or more arrays, multiplies …

Continue Reading

Match first error in Excel

by

This tutorial shows how to Match first error in Excel using the example below; Formula {=MATCH(TRUE,ISERROR(range),0)} Explanation If you need to match the first error in a range of cells, you can use an array formula based on the MATCH and ISERROR functions. In the example shown, the formula is: {=MATCH(TRUE,ISERROR(B4:B11),0)} This is an array …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel NOT Function
  • How to use Excel OR Function
  • Extract multiple matches into separate rows in Excel
  • Invoice status with nested if in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to calculate next day of week in Excel
  • Count holidays between two dates in Excel
  • How to calculate working days left in month in Excel
  • Basic timesheet formula with breaks in Excel
  • Add business days to date in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • Categorize text with keywords in Excel
  • Group times into unequal buckets in Excel
  • Map text to numbers in Excel
  • How to randomly assign data to groups in Excel

General

  • Basic text sort formula in Excel
  • Currency vs Accounting Format in Excel
  • Convert column number to letter in Excel
  • 231 Keyboard Shortcut Keys In Excel
  • Lock Cells in a Worksheet Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning