Em Andamento

Create a particular formula in Microsoft Excel

Hello,

We are a shirt printing company and use Excel with formulas to quote prices to our clients. I want to make the quoting system more simple and add in some functions that will automatically choose the correct prices.

With the way our quote works we have several options to choose, from how many colours, how many screens and how many shirts.

I need the formula to select the right price depending on the shirt qty and amount of colours selected.

Example:

If you want 60 shirts with 1 colour the price will be $1.35 per shirt for the ink.

But if you want 40 shirts with 1 colour the price will be $1.65 per shirt

Or if you got 60 shirts with 3 colours the price will be $1.80 per shirt for the ink.

The ink quantities range between 0-12, the shirt qualities use price brackets like:

1-25 shirts equals $xx price

25-50 shirts

51-125 etc all the way to 5000+ shirts

So I would need a formula that could choose the right price based depending on two different options (quantity of shirts and quantity of colours)

I already have the template made, I just need the formulas added in, any questions please let me know. Thanks!

Habilidades: Excel

Ver mais: microsoft excel formulas, how excel works, microsoft excel price, how to microsoft excel, create a shirt, microsoft company, excel add-in, excel add in, excel 50/60, microsoft excel template, microsoft formula excel template, price formula, questions formula, quantity template excel, simple excel formula, template formulas, excel template simple, excel based system, excel based quote system, excel quote system, quoting system excel, excel quoting, excel template formulas, quantity excel template, simple formula excel

Acerca do Empregador:
( 11 comentários ) Sydney, Australia

ID do Projeto: #7297077

Premiar a:

shikhamehta

Hey, I am an excel expert and can create the desired formula for you. This can be done in different ways. We may either add a table in your spreadsheet template which will have the price ranges defined or may have an i Mais

$30 AUD em 1 dia
(53 Avaliações)
5.2

3 freelancers estão ofertando em média $37 para este trabalho

dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mais

$30 AUD em 1 dia
(50 Comentários)
5.6
boriscikotic

Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: I Mais

$50 AUD in 2 dias
(4 Comentários)
3.3