Multiple fields and want only 1 answer = TRUE or = FALSE

Hello,

I have attached a workbook with a formula that I believe will help you. If you are unable to open the workbook the formula is below. I hope this helps!


=IF(AND(B6,B7,B8,B9,B10=TRUE),"Correct","FALSE")

I super appreciate the help. Thank you very much, but I am looking for more than that.

I am not just looking for the statement to be made "Correct"

What I am trying to find is...

300415 is TRUE because all of the answers it has had is TRUE

300697 is TRUE because all of the answers it has are TRUE

301220 is FALSE because it has had 1 FALSE answer

What is going on in the spreadsheet is I am running a weekly report that is showing if a PO has been carried over from a previous week. If it has I am then evaluating if the PO delivery date has changed. What I have do is... If the date did change during any of the weeks when I ran the data that change is indicated as "FALSE"

Now what I need to do is find how many of times the corresponding data says FALSE. If it is FALSE even 1 time then it is always considered FALSE.

I would be more than happy to post the spreadsheet, but I am not sure how. I'm new to the forum and a bit lacking in my knowledge of how to post excel documents to them.

For the second part of your question, you could do a countif formual. Lets say you have a table like this:

A1 True
A2 True
A3 True
A4 False
A5 True

If you created a countif formula in cell A6 to count the True's, =countif(a1:a5,True) and then another countif formula in A7 to count the False's, =countif(a1:a5,False)

Then divide the two and click your % button. You can enlarge the range of the cells if you have a large report for example =countif(a1:a1500,True)

I think this is on the right track. I am trying to drop the redundancy in the report. My goal is:

300415 = TRUE
300697 = TRUE
301220 = FALSE

If there is 1 FALSE then they are all false. This report is something I am running once per week. It is keying FALSE if a date of a PO has been changed when it is being pulled from QuickBooks. If the date changed then I want it to say FALSE so I can then go back and see how many POs have been changed. This way I can then evaluate how many POs are never changed vs changed.

I think this is getting very close to what I need I just don't know how to drop all of the POs into 1 number field and have it = FALSE if it = FALSE even 1 time...

I would love to. I just don't know how to. I feel like a pain asking, but could you tell me how to do it?

Awesome! I really like this website and will be using it more often.

You will see a few other columns which are used to formulate the data or TRUE and FALSE.

Hopefully seeing this will make sense of what I am trying to accomplish.

Every time a PO# has been changed I formulated it to show as FALSE.

I can't think of a way to do it in one formula. How I would do it is copy column A to a separate tab, then go to Data, Remove duplicates. Assuming you copied the data into column A in the new tab, in cell B2 the following forumla would give you what you want: =IF(COUNTIFS('All Together'!A:A,A2,'All Together'!F:F,"FALSE")>0,"FALSE","TRUE"). Copy that formula down and that will tell you if the PO has had any FALSE hits in column F.

Of course,

TRUE = if the PO date has not been changed from the previous week. =IF(D2=E2,TRUE,IF(D2<>E2,FALSE))

FALSE = if the PO date does not match exactly from the previous week. Same formula as above, which would state if the 2 dates do not match exactly then it is considered a FALSE statement.

I used TRUE and FALSE just because it would be a way to decipher if the information was changed or not changed. What I am trying to find is if a PO has changed ever in its life, be it 2 weeks or 15 weeks, that if it has changed then it will flag a FALSE. I am trying to find how often POs are changed. I want to see how many POs go from being put into the system and not changed vs how many are changed. The goal is to never have them be changed, but as of now I am trying to gather the statistics to see what our current rate of POs being changed in their "lifetime" is.

Of course,

True is caused when the PO does not change dates at all.

False is if the date has changed.

As I run this report once per week, my goal is to see the life time of a PO# if it ever has the dates changed when I export the data from Quickbooks. I am trying to find the % of POs that are being changed during their lifetime. So I have associated weeks of data in this overall spreadsheet to show me each week and if the data ever = FALSE. If the data does ever = FALSE then the PO#, no matter how many times it has been in the spreadsheet will always = False. I only want the data to default to answer as the PO has change there for it answers false only once.

I hope that helped explain it.

It worked great. Thank you