revised: help with calculating 3 part function in excel

[Guest]

i forgot a few things to add:

i need help trying to make a function to calculate a few things. here is the
problem:

need to calculate 3 functions from 1.5million apples.

first: need to multiply 0.00001 fot the first 300,000 apples over 500,000
apples.
second: need to multiply 0.00002 for the next 200,000 apples over 800,000
apples.
third: need to multiply 0.00003 for the remaining apples over 1million apples.

lastly, i need the sum of these three calculations.

thanks again for your help.

 

[Domenic]

Assuming that A1 contains the amount, try...

First:

=MEDIAN(A1-500000,0,300000)*0.00001

Second:

=MEDIAN(A1-800000,0,200000)*0.00002

Third:

=MAX(0,(A1-1000000)*0.00003)

Then simply SUM these three amounts.

Hope this helps!