Excel Spreadsheet- Margin Calculator

In Progress

Hi,

We are looking for simple spreadsheet that automatically calculates sale price depending on quantity ordered.

I have a table set with margin percentage and we want to use that table to calculate sale price depending on quantity order.

For example- Someone wants a quote on product A based on X units what is the sell price.

We want to be able to automate this so we just have a field were we enter product name and units required. Then sell price is returned. You will need to create if functions. Please also allow for odd quantities. ie we enter 175 units. The formula will need to select the right price break. I also want to be able to change the margin percentages as need be.

See attached file for reference. I want to be able to add info into the green fields and sell price to be returned in the red cell.

Please submit your best pricing.

Thanks,

Skills: Excel

See more: margin calculator excel, excel margin calculator, margin calculator excel spreadsheet, calculator margin spreadsheet, margin calculator spreadsheet, simple margin excel, margin calculator excel add, excel margin spreadsheet, spreadsheet margin calculator, simple excel spreadsheet margin calculator, spreadsheet margin sell price, excel spreadsheet margin calculator, calculate margin percentage excel, margin spreadsheet, excel formula margin percentage, price margin excel spreadsheet, simple excel margin calculator, product pricing spreadsheet, pricing calculator excel, margin spreadsheet calculator, excel spreadsheet margin, margin spreadsheet excel, excel spreadsheet formula, pricing excel, price excel

Project ID: #1343264

Awarded to:

ExactSystems

Please see a better solution on PMB. regards

$50 AUD in 1 day
(2 Reviews)
4.3

26 freelancers are bidding on average $36 for this job

vbexcel

Excel/VBA expert.

$30 AUD in 0 days
(25 Reviews)
5.2
Teloquence

Consider it Done. Check your PM.

$30 AUD in 0 days
(49 Reviews)
5.2
binaryromel

##### Excel expert here! Please check PM. #####

$30 AUD in 0 days
(35 Reviews)
4.9
naveenvarthaan

Hi, I ready to complete this immediately. And am ok with your budget. Thanks, Naveen

$30 AUD in 1 day
(13 Reviews)
4.2
GoodResults

Hi, I am very interested. Thanks

$30 AUD in 1 day
(21 Reviews)
4.1
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I have viewed your attachment, and found that this is similar to my previous project...but that much more complicated than yours. I atta More

$30 AUD in 1 day
(13 Reviews)
3.8
ifaisal

Hello I can do this for you. I have expertise in Ms Excel. Regards Faisal

$30 AUD in 1 day
(3 Reviews)
3.3
LIMEXS

Please, check my PM.

$30 AUD in 0 days
(5 Reviews)
3.1
ruchipuri

Please check PM.

$30 AUD in 0 days
(3 Reviews)
2.9
esalem

Hello, please see the PM for details.

$30 AUD in 1 day
(8 Reviews)
2.8
Dilipjaipur

Hi, pls check PMB. Thanks

$34 AUD in 1 day
(5 Reviews)
2.7
manohartvs

Hi There, Updated Bid: Please check your PM. I can have your Price calculator working for you by tomorrow. But I do have some potential questions in order to further my understanding of what is best for yo. I am More

$30 AUD in 1 day
(3 Reviews)
2.7
balakln

I am ready to do it. Please see the pm.

$30 AUD in 0 days
(2 Reviews)
1.9
Razacma

Please check PM

$30 AUD in 0 days
(1 Review)
1.0
hiAdil

i have created excel trackers for many companies and people. very familiar with if , nested if, v lookup, h lookup. In fact i do training's on Microsoft office tools. Would be happy to help.

$80 AUD in 2 days
(0 Reviews)
0.0
umapujar

please give me a chance.

$30 AUD in 2 days
(0 Reviews)
0.0
ganopoti07

Hello sir i am interested on your project.Let me provide details and check PM.

$30 AUD in 1 day
(0 Reviews)
0.0
ViktorBatalski

Hello, very interested in this project, regards, Viktor.

$30 AUD in 3 days
(0 Reviews)
1.0
venstoich

I am ready for that

$30 AUD in 0 days
(0 Reviews)
0.0
jethrusia

I am good in MS Excel and i know i am able to help you

$100 AUD in 5 days
(0 Reviews)
0.0