Help with a formula please

[dtiemeyer]

I'm struggling with what I think should be possible through If/Then formulas.

I have 2 shared parameters that I want to parse, the first I'm looking for an explicit match in value, the second, I'm looking to find if a value falls within a certain range. I thought a combination of IF with IFAND could get the job done, but it's throwing "Bad If-statement" error. Is what I'm attempting here possible? 

[RLY_15 · Accepted solution]

Looks like you're missing a false condition on the initial if statement.

Your logic statement is currently: if(Condition1, True)

Where True is: if(and(Condition2,Condition3), 1, 0)

So your initial logic test is incomplete.

---------------------

If the goal is to output 1 or 0, you can write it up as:

if(and(Length = 0' 8", Number > 145, Number < 650), 1, 0)

Logical AND can accept more than 2 conditions.

[dtiemeyer]

@RLY_15 Thank you very much! I didn't realize the AND operator could have more than 2 conditions. Your bottom suggestion is exactly what I was looking for!