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

Data Analysis

  • How to count table rows in Excel
  • How to create running total in an Excel Table
  • Subtotal function in Excel
  • Remove Duplicates Example in Excel
  • Example of COUNTIFS with variable table column in Excel

References

  • Last row number in range
  • Two-column Lookup in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to get last row in numeric data in Excel
  • Merge tables with VLOOKUP in Excel

Data Validations

  • Excel Data validation specific characters only
  • Excel Data validation must contain specific text
  • Prevent invalid data entering in specific cells
  • Excel Data validation must begin with
  • Excel Data validation exists in list

Tag: ISNONTEXT 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

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 FALSE Function
  • Complete List of Excel Logical Functions, References and Examples
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel

Date Time

  • Calculate date overlap in days in Excel
  • Convert Excel time to decimal hours in Excel
  • Convert Excel time to Unix time in Excel
  • Calculate number of hours between two times in Excel
  • Get first day of month in Excel

Grouping

  • Running count group by n size in Excel
  • Map text to numbers in Excel
  • Group numbers with VLOOKUP in Excel
  • Group numbers at uneven intervals in Excel
  • If cell contains one of many things in Excel

General

  • How to calculate percentage discount in Excel
  • How to create dynamic named range with INDEX in Excel
  • Excel Operators
  • How to password protect excel sheet?
  • Hide and Unhide Columns or Rows in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning