For what you are doing you are better off with a vlookup or similar type of
formula.
--
HTH...

Jim Thomlinson


"Eden397" wrote:

The cell W2 has the option of being 7 different text variables. I want to do
an if/then formula but can't seem to next it appropriately. Can anyone help?
Thanks.

=IF(W2="BP","N/A",0),IF(W2="DM F","F",0),IF(W2="DM M","M",0),IF(W2="1
week","U",0),IF(W2="0 week","U",0),IF(W2="DG F","UNK",0),IF(W2="DG M",
"UNK",0)