You mean:

=IF(E33="12x",F33*0.7*0.8,IF(E33="6x",F33*0.7*0.5, ""))

or

=IF(E33="6x",F33*0.7*0.5,IF(E33="12x",F33*0.7*0.8, ""))


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552424