Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with formula
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |