Hi
I have a formula in cell C2. I need to amend it slightly whereby there is a status cell in B2. If the status shows closed, cell C2 also needs to show blank. Currently it shows overdue if the date in A2 is lapsed from the current date event though the status is closed.
Bookmarks