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

 

[Sufiyan97]

Try

=IF(B2="Ordered","",IFERROR(IF([@QTY]<=[@[Reorder QTY]],1,0),0)

 

[Fluff]

Hi & welcome to MrExcel.
How about

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

 

[fibertech]

Hi & welcome to MrExcel.
How about

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

perhaps I'm inputting the formula in wrong but I'm getting a syntax error when entered as a conditional formatting the entire table. or it just simply doesn't work when entered into the Q column

 

[fibertech]

Try

=IF(B2="Ordered","",IFERROR(IF([@QTY]<=[@[Reorder QTY]],1,0),0)

perhaps I'm inputting the formula in wrong but I'm getting a syntax error when entered as a conditional formatting the entire table. or it just simply doesn't work when entered into the Q column

 

[Fluff]

That formula is meant to go in col Q not the conditional formatting rule.

 

[fibertech]

That formula is meant to go in col Q not the conditional formatting rule.

I slightly modified your answer to =IF(AND([@Notes]="ordered",[@QTY]<=[@[Reorder QTY]]),0,1) and it worked (Column Q)! Thank you for putting me in the right direction.

 

[fibertech]

I slightly modified your answer to =IF(AND([@Notes]="ordered",[@QTY]<=[@[Reorder QTY]]),0,1) and it worked (Column Q)! Thank you for putting me in the right direction.

i changed the grater than to Less than equal to.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[fibertech]

Try

=IF(B2="Ordered","",IFERROR(IF([@QTY]<=[@[Reorder QTY]],1,0),0)

I have retried this again and i gave you the wrong response. its saying the formual is missing an opening or closing parenthesis.