Excel ISBLANK - Free Excel Tutorial

If Cell is Not Blank

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some comments for not blank cells, you can build a formula with IF function, IF function… read more »

If Cell is Blank

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some comments for blank cells, you can build a formula with IF function, IF function can… read more »

How to ignore Blank Cells while Concatenating cells in Excel

This post will guide you how to concatenate cells but ignore all blank cells in your worksheet in Excel. How do I concatenate cells but ignore blank cells with a formula in Excel. How to create a concatenate formula to skip blank cells with user defined function in Excel 2013/2016. Concatenating Cells but Ignore Blanks… read more »

How to SUM Cells If the Adjacent Cell Match One Criteria in Excel

This post will guide you how to sum a given range of cells that if the adjacent cell meet one criteria in Excel. How do I sum All Cells if its adjacent cell is blank or equals to zero or contain a specific text string value with a formula in Excel. SUM Cells If the… read more »

How to Find the First or Last Non-blank Cell in a Row or Column in Excel

This post will guide you how to find the first non-blank cell in a row or column or a range in Excel. How do I get the value of the last non-blank cell in a row or column using formula in Excel. Get First Non-blank Cell Value Get Last Non-blank Cell Value Get First Non-blank… read more »

Ignoring Blank or Zero Cells with Conditional formatting

This post will guide you how to make conditional formatting ignore blank cells or zero cell in Excel. How do I force blank cells or zero cells to be ignored in conditional formatting in Excel. How to ignore blank cells or blank cells when applying conditional formatting in Excel.  Ignoring Blank with Conditional Formatting When… read more »

Excel IF formula with NOT logical function

This post will guide you how to use excel if formula with NOT logical function in Microsoft excel. NOT Logical Function The syntax of NOT logical function is as follow: =NOT(logical_value) The NOT logical function will return the reversed logical value. If the logical_value is TRUE, then FALSE is returned. If the logical_value is FALSE,… read more »

Excel Nexted IF Functions (Statements) Tutorial (15 IF Formulas examples)

This tutorial will guide you how to use nested Excel IF function  (include multiple If statements in excel formula) with syntax and provide about 15 nested IF formula examples with the detailed explanation in Microsoft excel. Nested If function Description Nested If Function Syntax Examples of Nested IF function in Excel Nested If Functions(Statements) Order… read more »

Excel ISBlank Function

This post will guide you how to use Excel ISBLANK function with syntax and examples in Microsoft excel. Description The Excel ISBLANK function returns TRUE if the value is blank or null. The ISBLANK function is a build-in function in Microsoft Excel and it is categorized as an Information Function. The ISBLANK function is available in Excel… read more »

Sidebar