I am trying to create a “calculator” within a Google Sheet that spits out a total percentage of compliance within given dimensions. Basically, I’m comparing an inputted length/width/height against set columns with values for length, width, and height.

Compliance document

https://docs.google.com/spreadsheets/d/1ognDpUEnT6jh5hygIeS6tDRR24WQFSB98igEvK-TpP0/edit?usp=sharing

above is an example of what I’m trying to accomplish. I’ve tried calculating the SUM/average of each column and then comparing the inputted dimensions but it turned out funky. I’m not very good with Google Sheets so I would really appreciate the help!