I have the following formulas in column F


(a) =IF(G2="Completed","-"

(b) =IF(E2="","",TODAY()-E2))
What I need it to do is if cell G" = Completed, then it puts a - in the relevant cell in column F. The formula labelled "A" does this

If there is no value in the cell in column E, I want the formula to leave the cell in column F blank The formula labelled "B" currenly does this


What I am unable to do is combine both formulas. Can someone please advise