Return value when two conditions are met

[Blaon]

Hello, I would appreciate some help to finish a formula, I am a bit stuck at the moment.

I attached an XSL with similar table for more clarity.

What I am trying to achieve is to return a "DANGER" text in the last column of my table when two conditions are met simultaneously, not just one or the other.

Currently, the "DANGER" is returned when:
A) the 4th column ("Duplicados") contains a text value "Duplicado" (I realise this one is a wrong approach, but can't think of a good way to do it)
B) the 3rd column "Quantity"'s value is greater than 99. (This condition should be fine)

However, what I would actually need is a slight change of the first condition, so the "DANGER" text value is only returned when Quantity is greater than 100 in duplicated products.

If Two (or more) clients order +100 oranges, then I need the DANGER value to be returned for those oranges whose quantity value is +100, not the -100 oranges.

So, for example, in this mock document, Orange should have the "Danger" Value because at least two clients asked for more than 100 oranges, but not the apples because only one client asked for more than 100 apples.

Thanks a lot in advance (and sorry if I didn't explain myself well)

[Bo_Ry]

Is this right?

Please try at E2 and drag down

=IF((SUMPRODUCT(--(($B$11:$B$17=B11)*$C$11:$C$17>99))>1)*(D11="Duplicado")*(C11>99),"DANGER","OK")
or
No need column Duplicados
=IF((SUMPRODUCT(--(($B$11:$B$17=B11)*$C$11:$C$17>99))>1)*(COUNTIF($B$11:$B$17,B11)>1)*(C11>99),"DANGER","OK")

[Blaon]

Edit: It does actually work, I must have copied something wrong. Thank you a lot!!