ExcelBanter - Formula to multiply numbers intervals

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to multiply numbers intervals (https://www.excelbanter.com/excel-worksheet-functions/449651-formula-multiply-numbers-intervals.html)

Carpe Diem

Formula to multiply numbers intervals

Hi all,

I need to arrange a formula to calculate the following :

< 80.000 < 150.000 150.000
a $0,460 $0,440 $0,400
b $0,120

A 175000
B 125000

I need for case A which is equal to 175.000:
A= 80000*.46+70.000*.44+25.000*.40

I tryed sumproduct but I could do it

Thanks in advance

Carpe

Claus Busch

Formula to multiply numbers intervals

Hi,

Am Fri, 27 Dec 2013 05:08:28 -0800 (PST) schrieb Carpe Diem:

< 80.000 < 150.000 150.000
a $0,460 $0,440 $0,400
b $0,120

A 175000
B 125000

I need for case A which is equal to 175.000:
A= 80000*.46+70.000*.44+25.000*.40

your value in A1. Then:
=MIN(80000,A1)*0.46+(A180000)*MIN(70000,A1-80000)*0.44+(A1150000)*(A1-150000)*0.4

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

All times are GMT +1. The time now is 07:34 AM.