Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to get address of last cell in range in Excel
  • Two-way lookup with VLOOKUP in Excel
  • Lookup entire row in Excel
  • Count rows with at least n matching values

Data Analysis Examples

  • How to Create Area Chart in Excel
  • Get column name from index in Excel Table
  • How To Perform and Interpret Regression Analysis in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Excel Bar Chart

Data Validation Examples

  • Excel Data validation whole percentage only
  • Data validation must not exist in list
  • Excel Data validation require unique number
  • How To Create Drop-down List in Excel
  • Excel Data validation date in next 30 days

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 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

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

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

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

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

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 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

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

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 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

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
  • Replace one character with another in Excel
  • PROPER function: Description, Usage, Syntax, Examples and Explanation
  • How to count number of characters of text in a cell in Excel
  • Extract last name from full name — Manipulating NAMES in Excel
  • TRIM function: Description, Usage, Syntax, Examples and Explanation
  • Get age from birthday in Excel
  • How to join date and text together in Excel
  • Add years to date in Excel
  • Convert date to month and year in Excel
  • Add workdays to date custom weekends in Excel
  • Calculate loan interest in given year in Excel
  • Compound Annual Growth Rate CAGR formula examples in Excel
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • FVSCHEDULE function: Description, Usage, Syntax, Examples and Explanation
  • Example of Future value of annuity in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles