OK, based on my interpretations then... perhaps
(I'm assuming the syntax for the inline array is correct for your client locale - if not you will need to tell me where you're located)![]()
=REPT("OK";IF(B7=1;AND(D7=1;E7=1);A7<INDEX({10000;25000;50000};MATCH(1;F7:H7;0))))
Bookmarks