ExcelBanter - If then statement continued!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If then statement continued! (https://www.excelbanter.com/excel-discussion-misc-queries/115426-if-then-statement-continued.html)

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?

If then statement continued!

Try:

=IF(OR(AND(I221 ="mudstone",J22199,I222 ="coal",J22249),AND(I220
="mudstone",J22099,I221 ="coal",J22149)),1,"")

Regards

Trevor

"Add to distribution list without opening"
icrosoft.com wrote in
message ...
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?