In IF formula, ISBLANK function returns FALSE in the logical_test argument if a cell is Not Blank, so value_if_true argument returns blank value and a value_if_false argument returns a value “Delivered”. This approach is opposite to first one above. In this approach, the logical expression Not Equal to Blank (“” ) returns TRUE in the logical_test argument if a cell is Not Blank, and the value_if_true argument returns a value “Delivered”, otherwise value_if_false argument a blank value. In both approaches, following would be the IF formula Otherwise it returns TRUE if a cell is blank.įor example, you need to evaluate that if a cell is Not Blank, then return a value “ Delivered”, otherwise return a blank value. In case of the ISBLANK function, the logical_test argument returns FALSE if a cell is Not Bank. In case of logical expression Not Equal to Blank (””) logical_test argument returns TRUE if the cell is Not Blank, otherwise, it returns FALSE. To evaluate the cells are Not Blank you need to use either the logical expression Not Equal to Blank (””) of ISBLANK function in logical_test argument of IF formula. Otherwise, the value_if_false argument returns value “Delivered”. In both of the approaches, logical_test argument returns TRUE if a cell is Blank, and the value_if_true argument returns the blank value. In both methods logical_test argument returns TRUE if a cell is Blank, otherwise, it returns FALSE if the cell is Not Blankįor example, you need to evaluate that if a cell is Blank, the blank value, otherwise return a value “Delivered”. To evaluate the cells as Blank, you need to use either logical expression Equal to Blank (=””) of ISBLANK function inthe logical_test argument of the IF formula. If a cell is blank, then it returns TRUE, else returns FALSE.įollowing examples will explain the difference to evaluate Blank or Not Blank cells using IF statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |