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.
26 freelancers are bidding on average $36 for this job
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.