IF statement
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
Only if what exceeds 7 days? I assume you mean that L8 and M8 contain
dates. I wonder if this is what you want:
=if(L8-M8<=7, "", if(or(E8="TBG",E8="PL"), L8-M8, ""))
That can also be written:
=if(and(L8-M87,or(E8="TBG",E8="PL")), L8-M8, "")
That says: display L8-M8 only if E8 is TGB or PL and L8-M8 exceeds 7
days; otherwise, display a blank cell.
|