Only some basic principles like presentation in Excel format and several (very few). Macedonia and Ukraine have been invited to participate in the TEM and TER. Display nothing if cell is blank To display nothing if a cell is blank, you can replace the 'value if false' argument in the IF function with an empty string (') like this. The effect of showing 'Closed' in light gray is accomplished. If the cell contains value (a date in this case, but it could be any value) the formula returns 'Closed'. If a cell is blank, the result is a status of 'Open'. In column E, a formula checks for blank cells in column D. In the example shown, column D contains a date if a task has been completed. = (D5 = ', 'Open', 'Closed' ) How this formula works The logical expression =' means 'is empty'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |