Something like this is probably what your looking for

=IF(AND(B2=1,C212),(0.1*A2),IF(AND(B2=2,C210),(0 .1*A2),...

"pdgood" wrote:


I'm trying to find a formula that adds to the pricing in certain
situations:
If B2=1 and C212 then I want to add .10*A2 If not 0
If B2=2 and C210 then I want to add .10*A2 If not 0
If B2=3 and C28 then I want to add .10*A2 If not 0
etc. through 12 possibilities for B2
Thanks.


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=534656