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?
"NOT OK"
is returned for the sample data because of the AND. You should approach your rules descriptions using math's order of operations. Use brackets to make clear what is inclusive, exclusive, etc. Rule 6 is unnecessary as those cells appear nowhere else in the rules ergo are already ignored etc. Your examples should show results