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

Data Analysis

  • Excel Bar Chart
  • How To Remove Duplicates In Excel Column Or Row?
  • How To Sort One Column or Multiple Columns in Excel
  • Subtotal function in Excel
  • How to create running total in an Excel Table

References

  • How to get first row number in range in Excel
  • How to use Excel MATCH Function
  • Create hyperlink with VLOOKUP in Excel
  • Extract all partial matches in Excel
  • How to use Excel LOOKUP Function

Data Validations

  • Excel Data validation must not contain
  • Excel Data validation unique values only
  • Excel Data validation don’t exceed total
  • Excel Data validation only dates between
  • Data validation must not exist 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

  • OR function Examples in Excel
  • IF with wildcards in Excel
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function

Date Time

  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation
  • How to determine year is a leap year in Excel
  • Assign points based on late time in Excel
  • How to calculate Quarter of Date in Excel
  • Get project midpoint in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • Group times into unequal buckets in Excel
  • Map text to numbers in Excel
  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to calculate percentage of total in Excel
  • How to set or clear a print area in Excel Worksheet
  • How to calculate project complete percentage in Excel
  • Creating and Opening an existing file in Excel
  • 3D SUMIF for multiple worksheets in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning