Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

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
0
acpress
Asked:
acpress
  • 3
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
The answer to the first problem: an IF statement has three arguments =IF(criteria,answer1,answer2). In your formula, F5="Validator", you have an answer1, but you have no answer 2. In those circumstances, if the criteria is not met, the answer is by default FALSE. If you don't want this, put in an answer2.

I suspect you want the null string "" (that's two speech marks), which results in a blank.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Here's the solution to your second problem:

=if(and(or(f5="Validation",f5="Scanner"),N5="WO#"),"Y","")
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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).
0
 
acpressAuthor Commented:
Thank you , Perfect, exactly what I needed,  Your explanation makes it easier to understand too.
0
 
acpressAuthor Commented:
perfect the right time.  excellent solution.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now