four input single output logic problem

Greetings. I need help with a logic problem in excel. The attached is a simplified sheet from a very complicated workbook. The inputs are actually named ranges from other sheets.
Basically given the 4 inputs I need to get the results on the goal column for the various input combinations. The helper columns previously set me up for the final goal.
This was working but I had add other options that require this “truth table”(if I’m using that term correctly). As you can see in the output tests column I’ve tried basic AND/OR logic. AND comes close but I need to take into account something else.
This looks simple and I’ve messed with it a bit but logic is not one of my strengths. Maybe someone can set me strait.
Thanks
Robert
LogicBlues.xlsx

F13:G14 have the same answers for the helper columns, but different answers in the goal. not sure i understand the logic here. If both helper columns are true, then u want true. IF they are both false you want false and if they are true and false, then what?

Originally Posted by ajm123456789

F13:G14 have the same answers for the helper columns, but different answers in the goal. not sure i understand the logic here. If both helper columns are true, then u want true. IF they are both false you want false and if they are true and false, then what?

ajm, "F13:G14 have the same answers for the helper columns, but different answers in the goal." F13:G14 are part of the helper columns so I don't understand what you mean.

The Helper columns may not be revelent any longer. they are just what I was using before. There may be a simple method to get the results in the goal from the corresponding input combinations.
thanks for taking the time to look at this. I'm sorry if my OP was not clear.

To clarify:

given the four input columns I need the to develop a formula(s) to get the results in the Goal column.

Output Tests are two things I tried that got close

hmm okay so disregard the helper columns completely
what is the logic for the inputs to get your goal?

IF IBC is bad it needs a disp. If Ducer is bad it needs a disp
if they are both bad they need only one disp or both disps?

use this formula and drag down
=IF(AND(SUM(B6:C6)=2,SUM(D6:E6)>=1),TRUE,IF(OR(B6>D6,C6>E6),FALSE,TRUE))

ajm123456789 and tigeravatar. all there solutions work perfect.
Thank you very much!
Robert