help with formula

[Mike Busch]

I was going to have form submitted to me from a site. The data comes in the
form of headers representing fields and the answers as number. So if it was a
yes or no answer, the Yes is represented by a 1 and the no is a 2. Is there a
formula that would change the number to a word. Thank you in advance.

Hi

It depends whether you want to replace your Yes and No with a number, or
have a separate value column.
For the first, you could use Find/Replace.
For the second, in blank column alongside the data you could use something
like this:
=IF(A1="Yes",1,2)

Hope this helps.
Andy.

"Mike Busch" <[email protected]> wrote in message
news:[email protected]...
>I was going to have form submitted to me from a site. The data comes in the
> form of headers representing fields and the answers as number. So if it
> was a
> yes or no answer, the Yes is represented by a 1 and the no is a 2. Is
> there a
> formula that would change the number to a word. Thank you in advance.

[Gary Schirmer]

Assuming the numerical information you want to decode into YES or NO is in
column A, type the following formula in Column B. (If there is data in
Column B, Insert a column between A and B continue)

=if(A1=1,"Yes","No")

Then copy formula down...

If you want to permanently replace the numbers with YES or NO, you can then
copy column B and Paste Special it to Column A as "Values". This copies in
the results of the formula, rather than the formula itself... (obviously you
can then delete column B.)

"Mike Busch" wrote:

> I was going to have form submitted to me from a site. The data comes in the
> form of headers representing fields and the answers as number. So if it was a
> yes or no answer, the Yes is represented by a 1 and the no is a 2. Is there a
> formula that would change the number to a word. Thank you in advance.