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