Excel Enter Value only IF Row contains specific text <p>I have this formula that I use to calculate lead-time for jobs which works great for what I have needed. Now my job data is going to change in each row and the data I need will not always be in the same column as it once was. What I need to do is add to my existing formula to only fill in the leadtime IF any cells in the row contain the text "COMPLETED", otherwise leave the cell blank. Can anyone help with this?</p> <pre><code>=(IF(ISBLANK(P1),"",(IF(P1-G1&lt;7,IF(WEEKDAY(P1)&gt;WEEKDAY(P1),P1-G1-2,P1-G1),(P1-G1-(ROUNDDOWN((P1-G1)/7,0)*2)))))) </code></pre>