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?
|