Conditional Formatting Question

[cionnaith]

Hi Folks.

I am trying to assign numerical values in one cell for categorical entries in another cell. The response options for the entry cell are "yes" or "no". I came up with the formula below and it works great for this. However, I need to add another condition for an entry cell that is empty. As it is, if that entry cell is empty, this formula returns a "FALSE". If the entry cell does not have either a "yes" or "no" selected, I need to have the computation cell remain empty with nothing in it.

=IF(J20="Yes",1,IF(J20="No",2))

Any help is most appreciated.

 

[Andrew Poulsom]

Try:

=IF(J20="Yes",1,IF(J20="No",2,""))

 

[VoG]

Try

=IF(J20="","",IF(J20="Yes",1,IF(J20="No",2)))

 

[cionnaith]

Thanks for the replies. Yours worked great Andrew. Thanks again folks!