Hey Bill,
Just out of curiosity, can ya make it work if more than one has a number. I
have always thought that it would not be possible, or a complete programming
nightmare.
"bill k" wrote:
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