I have trouble with creating a complex conditional formula in Google Sheets. Honestly, I feel there is a need for some script with a "for" cycle, but I'm not sure.
The task is the following. I have a table with countable and text data. Based on the values of the "Result" cells there could be the filled-in decision cell with a text either "OK" or "NOT OK". See the screenshot and google sheet file below. Could you please help?