Excel with advanced formulas calculating pricing

$10-30 USD

Closed

Posted

almost 5 years ago

$10-30 USD

Paid on delivery

Hi, I have the Excel sheet with the list of products with prices and the field with order quantity - user enters the number (units) of product that he wants to buy from us. Each product is in different row. Products are grouped into categories. I need advanced formulas that: - reduce the unit price if the total order price from the particular group is higher than A, B, C (numbers are given for each category) - reduce the unit price if the total order price is higher D (number is given) - reduce the total order pice (adds additional discount) if the date of order (TODAY DATE is higher on lower then 12.08.2019)

Excel

Data Processing

Data Entry

Project ID: 20546736

About the project

52 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

52 freelancers are bidding on average $25 USD for this job

@rashedkhanrubel

Hi, I have understand the project requirement & interested to make discount formula for this project. Please send a message so we can discuss more & start the project. Thanks.

$15 USD in 1 day

5.0

(466 reviews)

8.1

@elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards

$50 USD in 3 days

5.0

(338 reviews)

7.5

@Tanmoy236

"I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 8 years of experience in Sales, Marketing and Advertising. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "

$35 USD in 7 days

4.9

(281 reviews)

7.1

@AnowarRatul

$14 ONLY!!! In just 1 Hour!! [EXCEL FORMULA EXPERT] Sir, please CONTACT with me, I can SEND you a DRAFT project file to ensure my EXPERTISE. If you are 100% satisfied first, then please award me the project. You can see my profile to get overview of what my past employers think about me. I will be very much grateful if I get opportunity to work for you. Thanks, Anowar

$14 USD in 1 day

5.0

(424 reviews)

6.9

@suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash

$100 USD in 7 days

4.7

(95 reviews)

6.9

@razvancotofana

Hi, I have sound experience in excel and I can help you create the formulas you are looking for. BR, Razvan

$20 USD in 7 days

5.0

(21 reviews)

6.1

@ibrahimanjum330

Hi, I am Ibrahim and I am a data scientist, I can work on this excel project, and know formulas that can do all that. What is your budget? Regards, Ibrahim Anjum

$20 USD in 7 days

4.9

(69 reviews)

5.8

@afenache

Hi, I can write the needed formulas to apply discounts on each indvidual price according to your criteria. Best regards, Florin Enache

$30 USD in 1 day

5.0

(23 reviews)

5.7

@umairabdillah12

Hi There, I can help you to create advance formula for your data products, i have many experience in excel over 10 years, please kindly check my profile. hope can help you. thanks. regards.

$30 USD in 2 days

5.0

(25 reviews)

5.1

@Rina247

Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task. I am a quick, reliable and efficient worker. I am available to start work immediately. Best Regards, Rina Chakrabortty

$20 USD in 7 days

4.8

(56 reviews)

5.1

@sajidkhan45

Hi, I am an excel VBA expert and went through your project description and the excel file attached. Its a straightforward job for me. I should be able submit the work back today. Looking for a long term association. Hope to chat with you soon mate! Thanks Sajid Khan

$25 USD in 1 day

4.3

(69 reviews)

5.8

@JSAConsultants

Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I will share my firm profile when you contact me. Thanks Regards Muhammad Zaman

$30 USD in 7 days

5.0

(16 reviews)

4.5

@xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Looking forward to hearing from you. Thanks.

$20 USD in 7 days

4.8

(10 reviews)

4.1

@caharshadshinde

Hi I am a Excel Expert and a finance professional. I can complete the work within 1 day and can start immediately.

$30 USD in 1 day

4.6

(10 reviews)

4.1

@samerbadee

Hi, I read your project description, and it seems to me basic requirements in Excel .. no big deal. I'm an MS Excel expert with over 15 years of spreadsheets experience in business and engineering. If you are interested, drop me a message via Chat . Have a great day. Samer

$40 USD in 2 days

5.0

(4 reviews)

3.3

@emirhodzic3

Dear, I'm mechanical engineer from Bosnia and Herzegovina with excellent excel skills. I can finish your project very fast and quality. Best regards.

$30 USD in 7 days

5.0

(8 reviews)

3.2

@hmehedy154

Hi there,At first take my sincere respect. I’ve checked the project details and I can do this project perfectly. I have huge experience in data mining, data extracting, data scraping, virtual assistant working with these projects. Waiting for your quick reply. Look forward to hearing from you soon. Best Regards mehedi hasan

$20 USD in 7 days

4.8

(13 reviews)

3.1

@AhmedRagab321

Dear I read your description and I have found that your job very interesting And it would be easy to be done at a short time you can see my work in the profile ---------------------------------------------------- it would be nice to work with you sir :-D Thanks

$14 USD in 1 day

5.0

(5 reviews)

2.6

@oyasniy

Hi, I would like to help you with your price calculation excel project. You can rely on me. I am an experienced developer. Looking forward to hear from you. Best regards, Oleg

$30 USD in 2 days