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