Problem with IF ELSE CRITERIA

[sharma1407]

Got stuck in applying the IF ELSE Statement

I have Data in column A, and it has related parts in Column 2. I have the result for Column 2 in True or False.
I want to get the result for A column as True & false, based on the result of column 2.

Column 1 Column 2 Column 3 Column 4
A 1 True
A 2 True
A 3 True
A 4 True
A 5 True

As mentioned above in example, my requirement is to get the result in column 4 as TRUE only if column 3 has all true, if any column 2 has value as False in Column 3, then the result should show False.

Need support for this.

[63falcondude]

Hello and welcome to the forum.

I recommend creating a small representative sample workbook along with the desired results (manually entered) based on the sample data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

[sharma1407]

Done. Attached the sample also.

[63falcondude]

Try this:

D2 =IF(COUNTIFS(A:A,A2,C:C,"FALSE"),"FALSE","TRUE")

Drag the formula down.

[sharma1407]

Thanks Alot...Its working....Just the issue is if I have more data in excel in which I am using this formula, the whole excel is getting hanged.

[63falcondude]

How much data are we talking about?

I don't think that it will help but you can try limiting the range from A:A to something like A$2:A$1000.