I seem to not be able to figure out the following formula. I am trying to
have the formula give back ascribed #'s per text value, if no text =0. Can
anyone help.
=IF(Q="Disastrous",1,(IF(Q="Unacceptable",2,(IF(Q= "Undesirable",3,(IF(Q="Neutral",4,(IF(Q="Acceptabl e",5,(IF(Q="Preferred",6)))))))))))