new to excel but learning fast... iferror with exceptions from multiple cells.

[fibertech]

currently what I have is:
in Q columns- =IFERROR(IF([@QTY]<=[@[Reorder QTY]],1,0),0) and I have changed it to read as a text "reorder" instead of a one and added the flag
i have also added the auto highlighting based on conditioning word "reorder/1" with code =$Q5=1 with red highlight
i then added formula: =$B5="ordered" with a no color highlight to remove the red highlight when we order equipment
***My question is this.
When column B says "ordered" how do i also remove, cancel out, negate column Q's "IFERROR" code so it removes the "1/Reorder" and the flag? and obviously i want the "IFERROR" code to still function like normal as long as "ordered" isnt in B2.
thanks in advance

 

[fibertech]

Glad we could help & thanks for the feedback.

whelp lol. i spoke to soon haha. it did something funky. thankfully i didnt save as i was just going back through to double check.
so as it stands. it is still up in the air as far as how to code this. sorry for the confustion

 

[Fluff]

In what way didn't this work

=IF(and([@Notes]="ordered",[@QTY]>[@[Reorder QTY]]),0,1)