İptal Edildi

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.

Beceriler: Veri İşleme, Excel, Microsoft Office, Visual Basic

Daha fazlasını gör: create excel formula, hire a freelancer to create excel heat maps, which of the following error values means that excel doesn t recognize your formula because there is either a misspelled functio, data processing, excel, visual basic, microsoft office, excel formula find instance column, excel formula instance column, create excel letter template, create excel survey template, Create excel Template, create excel file template, create excel template csv file, create excel report template, create excel database will create letters word template, excel formula create digit luhn number, excel formula compound percentage column, create excel macro run powershell script, create excel form template quickbook import

İşveren Hakkında:
( 1 değerlendirme ) New York, United States

Proje NO: #15868012

Bu iş için 7 freelancer ortalamada $48 teklif veriyor

P0L

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(288 Değerlendirme)
7.2
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(212 Değerlendirme)
6.8
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(56 Değerlendirme)
6.2
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(135 Değerlendirme)
6.4
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
4.3
rizwanjpi

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0