calculate training price list

G

Guest

Try...
=INT(D21/15)*6000+IF(D21-INT(D21/15)*15>10,6000,IF(D21-
INT(D21/15)*15>5,4500,IF(D21-INT(D21/15)*15>0,3000,0)))

Hope this works for you
-----Original Message-----
I want to create a function that would help me calculate
Click to expand...
a total price based on a formula where the total is
created based on a number in a column. For instance i
charge $3000 for a training class for a maximum of 5
people. The class cannot be more than 15 people and the
max price for 15 is $6000. So, the first five is 3000 and
each additional 5 is 1500. But if I have 20 people the
cost would be $9000, because there is a second class of 5
involved now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to auto calculate based on other variables 8
calculate percentage of pay based on days old 2
help w indirect and index,match 3
Problem with price per item calculator that needs to apply volumebased prices that stack 4
Formula re value in column C or D, calculations made on either in column E? 8
Pricing Analysis a bit convoluted 3
Calculated Field in Pivot Table 0
Month calculation from cost for a business plan - please help 3

Top