If then statement continued!

  • Thread starter Add to distribution list without opening
  • Start date
A

Add to distribution list without opening

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

=IF(AND(I221 ="mudstone",J221>99,I222 ="coal",J222>49),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?
 
T

Trevor Shuttleworth

Try:

=IF(OR(AND(I221 ="mudstone",J221>99,I222 ="coal",J222>49),AND(I220
="mudstone",J220>99,I221 ="coal",J221>49)),1,"")

Regards

Trevor


"Add to distribution list without opening"
 
Top