Excel Formula - Help

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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

Accounting Excel Mathematics

Project ID: #18559246

About the project

73 proposals Remote project Active 5 years ago

73 freelancers are bidding on average $23 for this job

javed1705

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

$20 AUD in 1 day
(568 Reviews)
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 More

$25 AUD in 0 days
(321 Reviews)
7.4
bilalmaher053

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

$30 AUD in 1 day
(259 Reviews)
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, More

$30 AUD in 1 day
(154 Reviews)
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 More

$25 AUD in 1 day
(237 Reviews)
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 More

$111 AUD in 3 days
(82 Reviews)
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 More

$30 AUD in 1 day
(55 Reviews)
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.

$30 AUD in 1 day
(177 Reviews)
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 in 10 days
(227 Reviews)
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 More

$30 AUD in 1 day
(96 Reviews)
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 More

$24 AUD in 1 day
(52 Reviews)
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 More

$40 AUD in 1 day
(82 Reviews)
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.

$25 AUD in 1 day
(81 Reviews)
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

$25 AUD in 1 day
(77 Reviews)
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

$30 AUD in 1 day
(64 Reviews)
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

$15 AUD in 1 day
(13 Reviews)
5.0
Tkameswari

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

$15 AUD in 1 day
(11 Reviews)
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 More

$15 AUD in 1 day
(18 Reviews)
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 More

$20 AUD in 1 day
(4 Reviews)
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 More

$10 AUD in 1 day
(2 Reviews)
2.2