acpress
asked on
Excel Formula
I have a formula (in Cell G5) that returns a value of "Y" when these tow conditions are met. F5 = "Validator" and Cell N5 = "WO#"
This is Current Formula: =IF(F5="Validator",IF(N5=" WO#","Y",) )
The first problem is that when F5 does not equal "Validator" the result is "FALSE"
The second problem. I want to add a parameter that will return the same results ( "Y" if met, and left blank if not met) when F5 equals either "Validator" or "Scanner" and N5="WO#".
Any suggestions. Thanks
This is Current Formula: =IF(F5="Validator",IF(N5="
The first problem is that when F5 does not equal "Validator" the result is "FALSE"
The second problem. I want to add a parameter that will return the same results ( "Y" if met, and left blank if not met) when F5 equals either "Validator" or "Scanner" and N5="WO#".
Any suggestions. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To understand it, find the innermost brackets.
In English, you say this OR that. In Excel, you say OR(this,that).
The same with AND - AND(this,that).
In English, you say this OR that. In Excel, you say OR(this,that).
The same with AND - AND(this,that).
ASKER
Thank you , Perfect, exactly what I needed, Your explanation makes it easier to understand too.
ASKER
perfect the right time. excellent solution.
I suspect you want the null string "" (that's two speech marks), which results in a blank.