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.
Hi, Col B = contains dates in the rangeCol 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. Read More