I have a spreadsheet schedule for different steel I-beams such that cell
A2 = 1-W, A3 = 2-W, A4 = 11-C, A5 = 21-L, etc. How do I setup an
if/then function that converts the cell value to a description. For
example, cell B2 would reference A2 and with the result "I-BEAM" based
on a function in cell B2 like: IF(A2=W,"I-BEAM",IF(A2=C,
"CHANNEL",IF(A2=L,ANGLE,"N\A")))


--
structuresc
------------------------------------------------------------------------
structuresc's Profile: http://www.excelforum.com/member.php...o&userid=36067
View this thread: http://www.excelforum.com/showthread...hreadid=558528