Excel Spreadsheet- Margin Calculator

This project was awarded to ExactSystems for $50 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 AUD
Total Bids
Project Description


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.


Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online