Excel Formula - Help

Lezárva Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

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

Számvitel Excel Matematika

Projektazonosító: #18559246

A projektről

73 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

73 szabadúszó tett átlagosan 23$ összegű árajánlatot erre a munkára

javed1705

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

$20 AUD 1 napon belül
(568 vélemény)
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 Továbbiak

$25 AUD 0 napon belül
(321 vélemény)
7.4
bilalmaher053

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

$30 AUD 1 napon belül
(259 vélemény)
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, Továbbiak

$30 AUD 1 napon belül
(154 vélemény)
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 Továbbiak

$25 AUD 1 napon belül
(237 vélemény)
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 Továbbiak

$111 AUD 3 napon belül
(82 vélemény)
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 Továbbiak

$30 AUD 1 napon belül
(55 vélemény)
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 1 napon belül
(177 vélemény)
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 napon belül
(227 vélemény)
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 Továbbiak

$30 AUD 1 napon belül
(96 vélemény)
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 Továbbiak

$24 AUD 1 napon belül
(52 vélemény)
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 Továbbiak

$40 AUD 1 napon belül
(82 vélemény)
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 1 napon belül
(81 vélemény)
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 1 napon belül
(77 vélemény)
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 1 napon belül
(64 vélemény)
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 1 napon belül
(13 vélemény)
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 1 napon belül
(11 vélemény)
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 Továbbiak

$15 AUD 1 napon belül
(18 vélemény)
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 Továbbiak

$20 AUD 1 napon belül
(4 vélemény)
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 Továbbiak

$10 AUD 1 napon belül
(2 vélemény)
2.2