Refine formula with an additional IF function that conflicts with an existing IF function.

[Lea]

Hello Smart Excel People!

I sure hope there is a kind soul out there willing to take pity on me. I have been trying to fine tune the formula below off and on for a few weeks now. I am just plain stuck on this one. I have not been able to figure it out and I sure could use some help, please.

In the formula below, everything works how I want it to except the part in red. Currently, if there is an error or if there is text, it displays the message TEXT – CHECK VISUALLY. What I would like the formula to do is if the value of cell J19 is PASS then " "- the cell is blank. If the value of cell J19 is an error or any other text, then display TEXT – CHECK VISUALLY. Another way to say it is if the cell value is pass, I want it to return a blank cell. But if there is any other text value, I would like the cell to say TEXT – CHECK VISUALLY.
The rest of the formula performs as it should.

=IF(B19=" ","",IF(ISERR(OR(NUMBERVALUE(J19),NUMBERVALUE(L19),NUMBERVALUE(N19))),"TEXT - CHECK VISUALLY", IF(OR(J19=" ",J19=""),"MISSING",IF(NUMBERVALUE(J19)<NUMBERVALUE(F19),"OOS",IF(J19=" "," ",IF(NUMBERVALUE(J19)>NUMBERVALUE(G19),"OOS",""))))))

Thank you for any help you can give,
Lea

 

[Fluff]

I need the result of pass in column J to be blank in column M

But that's what the formula I suggested does.

 

[Lea]

But that's what the formula I suggested does.

Hello Fluff,
You are right and I am wrong! The formula worked. I was pasting your formula into the wrong row.
Thank you so much for your help and patience. I appreciate you taking your time to help me with this.

Regards,
Lea

 

[Fluff]

Glad it's sorted & thanks for the feedback.