Formula to multiply numbers intervals

  • Thread starter Thread starter Carpe Diem
  • Start date Start date
C

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
 
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
Click to expand...

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.
 
Back
Top