View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
monkeytrader monkeytrader is offline
external usenet poster
 
Posts: 16
Default revised: help with calculating 3 part function in excel

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.