Formula error

[deb45]

Hello,
Trying to enter on formula but could not.
Sample file is attached with descriptions.

Can anyone help?


Regards,
Deb

 

[Hui]

Deb

I suspect you have a few )'s in the wrong spot
Does this work ?
=IF(AND(B4="F",C4="B",A4="PLATE",(D4-E4)>=0),0,IF(AND(B4="F",C4="0",A4="PLATE",(D4-E4)>=0),(D4-E4),IF(AND(B4="0",C4="0",A4="PLATE",(D4-E4)>=0),(D4-E4),IF(AND(B4="F",C4="0",A4="CN",(D4-E4)>=0),(D4-E4),IF(AND(B4=0,C4=0,A4="CN",(D4-E4)>=0),(D4-E4),0)))))

If not can you explain the logic ?

 

[John Jairo V]

Hi, @deb45!

Try this formulae:
=IF(AND(B4="F",C4="B",A4="PLATE",D4-E4>=0),0,IF(AND(OR(B4={"F";0}),C4=0,OR(A4={"PLATE";"CN"}),D4-E4>=0),D4-E4,""))

Blessings!

 

[deb45]

Hello Hui,

Logic is given in attached file.

Regards,
Deb

 

[deb45]

Hello John,

Thanks. What if new items are added?

Sample file attached.

Regards,
Deb

 

[deb45]

Hello John,

I mean to say if new item "LDN" is added and whether it satisfies either or both of conditions , target production will be 0.

What will be the formula?

Regards,
Deb

 

[deb45]

Hello,

I am uploading file afresh with logic given.

Pls look into.


Regards,
Deb

 

[John Jairo V]

I mean to say if new item "LDN" is added and whether it satisfies either or both of conditions , target production will be 0.

What will be the formula?

Regards,
Deb

With new logic, just little change in formulae:
=IF(AND(B4="F",C4="B",A4="PLATE",D4-E4>=0),0,IF(AND(OR(B4={"F";0}),C4=0,OR(A4={"PLATE";"CN"}),D4-E4>=0),D4-E4,0))

Maybe can be shortened like this:
=IF(AND(OR(B4={"F";0}),C4=0,OR(A4={"PLATE";"CN"}),D4-E4>=0),D4-E4,0)

Blessings!