Y=1, N=0 How?

  • Thread starter Thread starter moocar_99
  • Start date Start date
M

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.:)
 
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
 
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 *
 
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.:)
Click to expand...

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
 
A standard way of doing this kind of data transformation
is using LOOKUP (or VLOOKUP or HLOOKUP).
 
Back
Top