help with calculating 3 part function in excel
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.
|