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

Data Analysis

  • How To Insert and Customize Sparklines in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How to calculate current stock or inventory in Excel
  • How to Sort by Color in Excel

References

  • Find closest match in Excel
  • How to get address of first cell in range in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get address of last cell in range in Excel
  • How to use Excel FORMULATEXT function

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation must contain specific text
  • Excel Data validation date in next 30 days
  • Excel Data validation unique values only
  • Prevent invalid data entering in specific cells

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

How to count line breaks in cell in Excel worksheet

by

This tutorial shows how to count line breaks in cell in Excel worksheet using example below. To count total lines in a cell, you can use a formula based on the LEN, SUBSTITUTE, and CHAR functions. Formula =LEN(B5)-LEN(SUBSTITUTE(B5,CHAR(10),””))+1 Explanation In the example, we are using this formula: =LEN(B5)-LEN(SUBSTITUTE(B5,CHAR(10),””))+1 How the formula works First, the LEN function counts …

Continue Reading

How to count total words in a cell in Excel

by

To count the total words in a cell, you can use a formula based on the LEN and SUBSTITUTE functions. Formula =LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))+1 Explanation In the example shown, C3 contains this formula: =LEN(TRIM(B3))-LEN(SUBSTITUTE(B3,” “,””))+1 How the formula works SUBSTITUTE removes all spaces from the text, then LEN calculates the length of the text without spaces. This …

Continue Reading

Return blank if in Excel

by

This tutorial shows how to calculate Return blank if in Excel using the example below; Formula =IF(A1=1,B1,””) Explanation To return a blank result using the IF function, you can use an empty string (“”).  In the example shown, the formula in D5 (copied down) is: =IF(B5=1,C5,””) How this formula works This formula is based on the IF function, …

Continue Reading

If cell is blank in Excel

by

This tutorial shows how to calculate If cell is blank in Excel using the example below; Formula =IF(A1=””,”blank”,”not blank”) Explanation To test a cell and take some action if the cell is blank (empty), you can use the IF function. The formula in cell E5 is: =IF(D5=””,”Open”,”Closed”) How this formula works The logical expression =”” means “is …

Continue Reading

If cell is not blank in Excel

by

This tutorial shows how to calculate If cell is not blank in Excel using the example below; Formula =IF(A1<>””,”Not blank”,”Blank”) Explanation If you want to test a cell and take some action if the cell is not blank (not empty), you can use a simple formula based on the IF function. In the example shown, we have …

Continue Reading

Conditional formatting column is blank in Excel

by

This tutorial shows how to Conditionally format column is blank in Excel using the example below; Formula =OR(A1=””,B1=””, C1=””) Explanation To highlight values in one column when values in one or more other columns are blank, you can use the OR function and a basic logical expression to test for blank or empty values. In …

Continue Reading

Highlight blank cells in Excel

by

This tutorial shows how to Highlight blank cells in Excel using the example below; Formula =ISBLANK(A1) Explanation If you want to highlight cells that are blank or empty with conditional formatting, you can do so with a simple formula based on the ISBLANK function. For example, if you want to highlight blank cells in the range …

Continue Reading

How to use Excel NOT Function

by

This Excel tutorial explains how to use the NOT function with syntax and examples. Excel NOT Function Description The Excel NOT function returns the opposite to a supplied logical value. That is, If supplied with the value TRUE, the Not function returns FALSE; If supplied with the value FALSE, the Not function returns TRUE. Excel …

Continue Reading

Get first non-blank value in a list in Excel

by

This tutorial shows how to Get first non-blank value in a list in Excel using the example below; Formula {=INDEX(range,MATCH(FALSE,ISBLANK(range),0))} Explanation If you need to get the first non-blank value (text or number) in a in a one-column range you can use an array formula based on the INDEX, MATCH, and ISBLANK functions. In the …

Continue Reading

How to set check register balance in Excel

by

This tutorial shows how to set a check register formula that calculates a running balance and also, blank values using formula based on simple addition and subtraction. See illustrations below: Formula =balance-debit+credit Explanation In the example shown, the formula in G6 is: =G5-E6+F6 How this formula works The value in G5 is hard-coded. The formula picks …

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

  • Nested IF function example in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • Not Equal To ‘<>‘ operator in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • How to use IFS function in Excel

Date Time

  • How to calculate next anniversary date or birthday in Excel
  • Convert date to text in Excel
  • How to get same date next month or previous month in Excel
  • Convert date string to date time in Excel
  • Excel Date & Time Functions Example

Grouping

  • Running count group by n size in Excel
  • How to randomly assign people to groups in Excel
  • If cell contains one of many things in Excel
  • Group numbers at uneven intervals in Excel
  • Group times into unequal buckets in Excel

General

  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
  • How to get Excel workbook path only
  • How to create dynamic named range with INDEX in Excel
  • How to test a range for numbers in Excel
  • Count cells that contain errors in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning