Hello,
I am using Excel 365, and the following formula is not producing the results I am seeking,
=IF(AND(H:H>=1, OR(A:A="", A:A="WIP")), 1, ""), right now I am not seeing anything in column V.
The purpose of the Formula is to add total jobs that are being worked on (WIP) or that need to be worked on (Blank).
I need a number 1 placed in column V if all conditions are met and a 0 if there is anything else in Column A, as there are multiple letters that are auto populated due to other formulas.
I want to use a formula in a different cell to add up column V to let the inspectors know how many jobs are in the que.
AND and OR only return one result, not an array of results. so you would need to enter the correct formula into one cell and copy it down - eg
=IF(AND(H5>=1, OR(A5="", A5="WIP")), 1, "")
Hello,
That works great; However, it is displaying a 1 in column V when both columns are blank. I need a 0 where both are blank, since I am counting the 1's to show how many jobs are in QA.
Maybe
=IF(AND(H5>=1, OR(A5="", A5="WIP")), 1, IF(AND(H5="", A5=""),0, ""))
Thank You.
Have a great day!