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.
9 freelancers are bidding on average $42 for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
Hello, I am ready to work and i need to ask some question. Relevant Skills and Experience I have done 600+ projects on excel at Upwork. Proposed Milestones $30 USD - One time is good