IF statement

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

=IF(AND(OR(E8="TBG",E8="PL"),L8-M8>7),L8-M8,"")

assuming that if L8-M8<=7 you want blank and this covers the L8-M8 condition

 

[Guest]

=IF(AND(OR(E8="TBG",E8="PL"),L8-M8>7),L8-M8,"")

assuming that if L8-M8<=7 you want blank and this covers the L8-M8 condition

 

[joeu2004]

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-M8>7,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.

 

[joeu2004]

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-M8>7,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.