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. |
revised: help with calculating 3 part function in excel
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! In article , monkeytrader wrote: 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. |
All times are GMT +1. The time now is 02:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com