Hi all
I'm really struggling here - any help would be great. I have a spreadsheet where I am trying to record (in cell F4) that actions are either open or closed off. Where actions are open it is automatically highlighted red. I have the following formula.
=IF(E4<>"","Closed","Open")
all good so far....
I however would only like Closed or Open to show when cell B4 is populated. If it is not populated then i'd like the cell to remain blank. Is this do-able?
I'm really struggling here - any help would be great. I have a spreadsheet where I am trying to record (in cell F4) that actions are either open or closed off. Where actions are open it is automatically highlighted red. I have the following formula.
=IF(E4<>"","Closed","Open")
all good so far....
I however would only like Closed or Open to show when cell B4 is populated. If it is not populated then i'd like the cell to remain blank. Is this do-able?