Check Box if B/O Qty is > 0 OR Status column says "Backorder"

clairehunter

Hello,

I have been messing with this formula forever and I feel like I am just barely missing the mark, but cannot seem to figure it out nonetheless.

GOAL: If column: "B/O Quantity" = 0 check the box, OR IF column: "Status" says "Backorder" check the box. If both instances occur still check the box.

Okay, the formula I have so far is:

=IF(OR([Status]@row = "Backorder", ([B/O Quantity]@row = > 0, 1 0,)))

I am getting an incorrect syntax error. Thanks for the help!

JamesB

@clairehunter

You are not closing your OR statement before moving to your True/False in your IF command.

=IF(OR(Status@row = "Backorder", [B/O Quantity]@row >= 0), 1, 0)

clairehunter

@JamesB

It is still saying "the column formula syntax is incorrect".

JamesB

@clairehunter

I just copied and pasted the formula and I am not getting an error in my syntax.