The format is ‘=ISBLANK(value)’ for the value you can select the column delivery date corresponding to each order numbers. So can apply the formula ISBLANK to find the blank cells in the column delivery_date. Here you can consider the orders which do not have a delivery date marked can be considered as not yet delivered. Let’s find the orders which are not yet delivered. Order number and its delivery date are given. In following excel, given is the status of some orders. Where Value can be a cell reference Example 1 How to use ISBLANK? This is a simple function in excel, and the format is.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |