View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Add to distribution list without opening Add to distribution list without opening is offline
external usenet poster
 
Posts: 4
Default If then statement continued!

Alright - the help was excellent - I have another dilema - same project...

=IF(AND(I221 ="mudstone",J22199,I222 ="coal",J22249),1,"") This is what I
have so far. I want it to equal true if say line number 1 is a mudstone
greater than 99 and line number 2 is a coal greater than 49. Here is the
kicker... I want BOTH lines to show in the final filter.

Can you help?