Multiple AND must be satisfied, formula help please -

aiki100

Board Regular
Joined
Aug 16, 2016
Messages
83
Hello all - I am trying to figure out a way to do the following please, and could use some help:

I have the following headers:

A1 = TestA, B1= TestA Verified, C1= TestB, D1 = TestB Verified, E1= Time, F1= Time Verified, and finally G1 = All Tests Satisfied,

I have a lookup that populates the TestA, TestB, and Time cells in row2 with specific data I want to test for.

I then have a formula that looks across data elsewhere and checks to see if a populated test is in fact satisfied. If the test for TestA is satisfied, then an "x" will be marked in B2, (TestA Verified). If the test is not satisfied, then B2 is left blank.

G2 needs to have a formula that will mark an "x," ONLY IF ALL the populated criteria are satisfied, i.e., all are marked with an x. If all tests are not satisfied, then leave G2 blank.

I have some 15 tests that I have to use, and sometimes only 2 tests will be populated (and sometimes only one), and other times all 15 might be populated and testing. I don't know if this makes any difference, but thought I'd add in this information.

Does anyone have a thought on this please? Thanks in advance for the assistance!

















 

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
608
Can you post some sample data so we can look at it for you?
 

Forum statistics

Threads
1,082,509
Messages
5,365,982
Members
400,864
Latest member
alogia67

Some videos you may like

This Week's Hot Topics

Top