Formula Help

e.mcinnes66356

I am trying to have a formula in a cell that will total "1" if the Assigned to Column is a certain name, and the Status Column is QA, or fielded. 

This is what I have and I need Help please..... I know it is so wrong but I am lost on how to correct it.

=IF(STATUS672 = "QA" OR(STATUS672 = "FIELDED"AND([QA Assigned To]672 = "Bill"), "1")

 

e.mcinnes66356

I have come up with this, but I can't get the OR condition for the Status Column  for (STATUS672 = "QA") entered without UNPARSEBLE showing up.

 

 

=IF(AND([QA Assigned To]672 = "Bill", (STATUS672 = "FIELDED")), "1", "0")

 

Jacques@SBP

The way to do an OR with IFs is to do a "nested IF".  Try this:

=IF(STATUS@row = "QA", 1, IF(AND([QA Assigned To]@row = "Bill", (STATUS@row = "FIELDED")), "1", "0"))

e.mcinnes66356

That worked Perfectly, Thank you so much!

e.mcinnes66356

actually it only worked in Bill's column, when I copied the formula to Lorne's column and put his name in it still showed a 1 count even though it was Bills name in the QA Assigned to column.

And when the status changes to submitted it still shows 1 . I only want a count of 1 to enter into the cell if the status is QA or Fielded

 

Paul Newcome

Give this a try...

 

=IF(AND([QA Assigned To]@row = "Bill", OR(STATUS@row = "QA", STATUS@row = "FIELDED")), 1)