Thread: IF statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default 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