Here is the statement
I simply need this to resolve a value based on the set conditions. I've tried numerous variations but can't seem to get the second or third results.
Unsure if there is something that libreoffice needs that differs from excel format.
I should also state that the cell L7 is using the COUNTA function to get its result.