Create an Excel Formula

Looking to create formula for a standard template that I use on a daily basis. We use this as a quick qualifying for potentially interesting companies sourced from larger lists, conference lists, etc. I've attached a version of the template with a sample set of data, which I categorized manually. Ideally I would like to be able to run a formula in Column A to categorize "Priority" as a 1, 2, or 3. The criteria for the Priority categorizations are as follows: 3- (must meet at least 1 datapoint)- ownership status = "public" or "public sub" OR greater than $100M in total funding OR greater than 1000 employees 2- (should be catch-all for whatever is not a 3 or 1)- ownership status NOT "public" or "public sub" AND total funding between $99M - $60M AND/OR Less than 30 employees 1- (must meet all datapoints)- ownership status NOT "public" or "public sub" AND less than $59M in total funding AND between 999-31 employees If there are any question I'm happy to clarify in more detail.