a nested if?
this may help

enter in cell F1
=IF(A10,"O",IF(B10,"1.5",IF(C10,"2T",IF(D10,"S ",IF(E10,"V","")))))

this assumes that only one cell of the five has a number


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=481998