Formula to multiply numbers intervals

[Carpe Diem]

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]

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+(A1>80000)*MIN(70000,A1-80000)*0.44+(A1>150000)*(A1-150000)*0.4


Regards
Claus B.