Y=1, N=0 How?

[moocar_99]

I know this may same easy but Im new to Excel formulas. I have created a
spreadsheet where I want the response of Y or N to have a numerical
value. The values will be added up and averaged. Thank you for your
help.

 

[Peo Sjoblom]

One way, assuming cell A1 is the cell with the response

=--(A1="Y")

 

[Frank Kabel]

Hi
if you just want to count the number of 'Y' and 'N' you could use
COUNTIF. e.g. if your responses are stored in column A try
=COUNTIF(A1:A100,"Y")
to count als 'Y' responses

Frank

 

[A.W.J. Ales]

Moocar_99,

Where are those Y or N the response from ?

If it's the result of a formula like :

=IF(test,"Y","N") , simply replace the "Y" with 1 and the "N" with 0.


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Bill Plenge]

I know this may same easy but Im new to Excel formulas. I have

created a spreadsheet where I want the response of Y or N to have a
numerical value. The values will be added up and averaged. Thank you
for your help.

Assuming the cell containing the Y or N is A1 how about ....

=SEARCH(UPPER(A1),"NY")-1

Y or y will result in 1, N or n will result in 0, anything else will cause a
#VALUE error.

Hope this helps.

Best,
Bill

 

[Erich Neuwirth]

A standard way of doing this kind of data transformation
is using LOOKUP (or VLOOKUP or HLOOKUP).