Austin Lang
Board Regular
- Joined
- Sep 10, 2021
- Messages
- 51
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hello all,
I have created this piece of work and seem to have an issue..
=IF(ISBLANK(A5),"",IF(C5="Rinsed","Rinsed",IF(AND(NOT(ISBLANK(R5)))*AND(NOT(ISBLANK(S5)))*AND(NOT(ISBLANK(T5)))*AND(NOT(ISBLANK(V5)))*AND(NOT(ISBLANK(AK5)))*AND(NOT(ISBLANK(AN5))),"Pass","Fail")))
What I am looking for is if all of the specified cells are not blank, then show "Pass". If not, then show "Fail". The formula works beautifully as long as the cells are empty. The issue I have found is that the cells that this is referencing all have a separate formula in them. All of those formulas do have something along the lines of "IF(ISBLANK(A5),""..." All of the cells default to show nothing until someone enters something in the cell and overrides the formula. ISBLANK is recognizing the formulas in these cells and not allowing the formula to work properly. If I remove all of the formulas from the referenced cells, then it works flawlessly. Anybody have an idea on how to go about fixed this? Is there something other than ISBLANK that would work? Would COUNTA be better?
I have created this piece of work and seem to have an issue..
=IF(ISBLANK(A5),"",IF(C5="Rinsed","Rinsed",IF(AND(NOT(ISBLANK(R5)))*AND(NOT(ISBLANK(S5)))*AND(NOT(ISBLANK(T5)))*AND(NOT(ISBLANK(V5)))*AND(NOT(ISBLANK(AK5)))*AND(NOT(ISBLANK(AN5))),"Pass","Fail")))
What I am looking for is if all of the specified cells are not blank, then show "Pass". If not, then show "Fail". The formula works beautifully as long as the cells are empty. The issue I have found is that the cells that this is referencing all have a separate formula in them. All of those formulas do have something along the lines of "IF(ISBLANK(A5),""..." All of the cells default to show nothing until someone enters something in the cell and overrides the formula. ISBLANK is recognizing the formulas in these cells and not allowing the formula to work properly. If I remove all of the formulas from the referenced cells, then it works flawlessly. Anybody have an idea on how to go about fixed this? Is there something other than ISBLANK that would work? Would COUNTA be better?