IF(C4="National"(If (B4=850, D4*'customer account numbers'!C3),IF(
B4749, D4*'customer account numbers'!C4), IF(B4649, D4*'customer
account numbers'!C5)), If(C4="Regional"(IF (B2=850, D4*'customer
account numbers'!B3), IF(B4749, D4*'customer account numbers'!B4),
IF(B4649, D4*'customer account numbers'!B5)))

What is wrong with this formula?

Thanks,



Seanzie


--
Seanzie
------------------------------------------------------------------------
Seanzie's Profile: http://www.excelforum.com/member.php...o&userid=30992
View this thread: http://www.excelforum.com/showthread...hreadid=506598