# Formula Help

Options
edited 12/09/19

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")

• edited 03/16/19
Options

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")

• ✭✭✭
Options

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"))

• Options

That worked Perfectly, Thank you so much!

• Options

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

• ✭✭✭✭✭✭
Options

Give this a try...

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