Would this work for you? A1 holds the number of Apples?

=MAX(0,A1/100000 - 5, A1/50000 - 13, (3*A1)/100000 - 23)

--
Dana DeLouis
Windows XP & Office 2003


"monkeytrader" wrote in message
...
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.

sorry if my problem is unclear. i hope someone there can help me out.
thanks in advance.