try
=if(L8-M8=0,"",IF(or(E8="TBG",E8="PL"),if(L8-M87,L8-M7,"otherwise")))
putting in what you want for otherwise

"Connie Martin" wrote:

Can anyone help me, please? Need an IF statement that would go like this:

If L8-M8=0,"",if E8 has TBG or PL in it, then calculate the difference
between L8 and M8 only when it exceeds 7 days

Thanks a bunch
Connie