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

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