IF statement
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 |
IF statement
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 |
IF statement
=IF(AND(OR(E8="TBG",E8="PL"),L8-M87),L8-M8,"") assuming that if L8-M8<=7 you want blank and this covers the L8-M8 condition "bj" wrote: 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 |
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. |
All times are GMT +1. The time now is 03:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com