=IF(D3="four",4,IF(D3="five",5,IF(D3="six",6,8)))

"nitrofueled" wrote in message
...
I am trying to create a formula within a cell that returns a number (4,5,6,
or 8) based on a series of text entries. The text series are in seperate
columns that have been named (four, five, six and eight) on a seperate
sheet.
So far I have written this program with no success:
=IF(D3=four,"4",IF(D3=five,"5",IF(D3=six,"6","8")) ). Any help would be
greatly appreciated...