Excel Formula - Help

已关闭 已发布的 5 年前 货到付款
已关闭 货到付款

Hi, I urgently need assistance with an advanced excel formula which can classify

1. Gross Margin $'s and 2. Gross Margin %'s into classifications. The classifications are:

Classification 1: Gross Margin $ above $500,001 and Gross Margin % > 20%

Classification 2: Gross Margin $ $200,001-$500,000 and Gross Margin % > 20%

Classification 3: Gross Margin$ $20,001 - $200,000 and gross margin % > 20%

Classification 4: Gross Margin $ above $20,000 however gross margin % < 20%

Classification 5: Below $20,000 gross margin however gross margin % > 20%

Classification 6: Below gross margin $20,000 however gross margin % < 20%

Classification 7: anything with -$ gross margin $ and -%

Gross Margin $ and Gross Margin %'s tabular data provided

Can you create the formula in one line assuming GM$ is cell A1 and GM% is cell A2

Thank you

会计 Excel 数学

项目ID: #18559246

关于项目

73个方案 远程项目 活跃的5 年前

有73名威客正在参与此工作的竞标,均价$23/小时

javed1705

well, very easy for me to do this ... it is exactly like we are using tax calculation ... available for this task

$20AUD 在1天里
(568条评论)
8.1
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, they speak for themselves. Best rega 更多

$25 AUD 在0天内
(321条评论)
7.4
bilalmaher053

hey, i can create formula right now, can u please share file in chat?

$30AUD 在1天里
(259条评论)
7.0
hdlong66

Hello, You need help writing a formula which can classify Gross Margin $ and Gross Margin % into classifications. Could you please explain about the last classification (Classification 7)? Thank you and Best regards, 更多

$30AUD 在1天里
(154条评论)
6.9
priyal1997

Hi There, I can do this task PERFECTLY within few minutes for you. I am an expert in both excel and finance, and have already developed a lots of similar advanced formulas for businesses. You can refer my profile to 更多

$25AUD 在1天里
(237条评论)
6.8
kamrananjum1

Hi, I can help you with this one. I have more than 10 years of professional experience in Microsoft Packages. Please share some more details for quality work. I can do almost anything in MS Excel. Please also con 更多

$111 AUD 在3天内
(82条评论)
7.0
GopalJp

Hello Sir, I can help you on your project Excel Formula. I am an accountant having more than five years and expert in Microsoft Excel including VBA or Macros development. I am based in India and having experience in 更多

$30AUD 在1天里
(55条评论)
6.9
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$30AUD 在1天里
(177条评论)
6.9
nvchien94

Hello there, I am an Excel expert and I can give you the formula you want. Very fast result will be provide. I think only few mins. So please contact and I will do it for you. Thank you.

$15 AUD 在10天内
(227条评论)
6.6
ShaunKleinOnline

Hi there, If you haven't found someone to help you with your required classification formulas as of yet, I would love the opportunity to create it for you. The specifications make perfect sense. I would use a combin 更多

$30AUD 在1天里
(96条评论)
6.7
kelvinm094

Hi there, I am very proficient on accounting tasks using excel. I have done this for several years and so I am well versed with it. I can deliver exactly what you need in a single day and at a fair cost. If you 更多

$24AUD 在1天里
(52条评论)
5.6
archanaoswal

I have excellent command on MS Excel formulas and VBA. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimi 更多

$40AUD 在1天里
(82条评论)
5.9
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$25AUD 在1天里
(81条评论)
5.9
mail2vimalarora

Hi, Being experienced in working on several excel projects involving complex formula based on that I can quickly help you in writing it as needed. Waiting for your response for further discussion. Thanks

$25AUD 在1天里
(77条评论)
5.5
sevillajk01

hello! Looking for someone who specializes Excel! Then let me help you. I offer offer high quality and accurate output. Please see reviews on my previous projects to better assess my capability. thanks

$30AUD 在1天里
(64条评论)
5.4
arash18k

Hi, I can do this in max 1hr. we just need nested if for this. ping me and i will start writing it right away. Best Regards

$15AUD 在1天里
(13条评论)
5.0
Tkameswari

i can provide you calculations given as specifications on the excel. also, i will show them in a beautiful tabular form.

$15AUD 在1天里
(11条评论)
4.8
Rugues

Hi, Yeah it is very possible to classify the formula in one cell so that when one criteria is met, it gives the end result. I would love to discuss further through this platform so as to clarify some things to make it 更多

$15AUD 在1天里
(18条评论)
4.6
aftabahmad1994

Hello sir After going through the details of the project, I offer my services for this job. I can create formula which will be based on if else conditions to meet your requirements. You can check my portfolio by vis 更多

$20AUD 在1天里
(4条评论)
2.0
tarekgueham

I am Tarek from Alger, Amgeria, serving for more than 5+ Years all across the globe in the Industry of Web Development and graphic design. It will be my pleasure to work for. We are too sure about the quality and servi 更多

$10AUD 在1天里
(2条评论)
2.2