Mixing ands and Or within an If formula

Craig Lemberger

I am trying to get if purchased as stock is not checked AND a sting of ORs, then check this box.

=if(and([Purchased as Stock]@row=0,if(or(islank(Client@row),isblank(Item@row),isblank(Quantity@row),isblank([Purchase Price]@row),1,""))

Kelly Moore

Hey @Craig Lemberger

Try this

=if(and([Purchased as Stock]@row=0,or(islank(Client@row),isblank(Item@row),isblank(Quantity@row),isblank([Purchase Price]@row)),1)

Note how the ORs are closed with a parethesis then the AND is closed.

Does this work for you?
Kelly

Craig Lemberger

So nice of you Kelly, but it still is unparseable. :(

Kelly Moore

hey @Craig Lemberger

I see one ISBLANK you have misspelled that I didn’t catch earlier

Craig Lemberger

@Kelly Moore Indeed you are right. With that correction the comment went from unparseable to incorrect argument set. I love this but it drives me crazy sometimes. :)

Kelly Moore

@Craig Lemberger

Add another parenthesis in front of the ,1

Sorry but it’s hard to count parentheses when working off a phone. As mentioned earlier, you have to close both the And and the OR- in addition to any functions within those functions like ISBLANK. If your ending parenthesis isn’t blue, you don’t yet have the correct number of parentheses. The placement might not be correct, but the count is.
kelly

Craig Lemberger

thank you @Kelly Moore

I am close I think: I counted the parenthesis and even noted that they matched, but something is still no working:

=IF((AND([Purchased as Stock]@row = 0, IF(OR(ISBLANK(Client@row), ISBLANK(Item@row), ISBLANK(Quantity@row), ISBLANK([Purchase Price]@row))))), 1, "")

Kelly Moore

@Craig Lemberger

You put the second IF back in the formula as well as adding extra parenthis at the beginning. Neither belong.

=IF(AND([Purchased as Stock]@row = 0,OR(ISBLANK(Client@row), ISBLANK(Item@row), ISBLANK(Quantity@row), ISBLANK([Purchase Price]@row))), 1)

If this gives you an error, please take a screenshot of your formula with the colored text and parentheses.

Kelly

Kelly Moore

@Craig Lemberger

Are you good? Did you get it working?
Kelly