Good afternoon Amy

This formula when placed in cell F20 will do what you want. If F9
doesn't equal xa, tx or xb then the cell will show as empty.

=IF(F9="xa",133,IF(F9="tc",168,IF(F9="xb",155,"")) )

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=384943