Forum Discussion
If cell is true return nothing
Hi,
Col B = contains dates in the range
Col L = contains dates in some cells in the range
At the moment I am using the following formula:
=TODAY()-B12
Now I want to put a condition into the formula.
Whenever a cell in col L contains a value then return nothing
Thank you for taking an interest.
packie Perhaps this:
=IF(ISBLANK(L12),TODAY()-B12,"")
packie Perhaps this:
=IF(ISBLANK(L12),TODAY()-B12,"")
