How do I set up a formula to calculate a letter as a value

J

jk101133

I am trying to set up a formula that will take a character entered such as
"N" and then get it to change the "N" in to a weighted percentage. So for
example if I asked a question and the person's choice for response is Yes,
No, NA and they selected No or N the next column would represent that N or No
as .15
 
M

Max

Something using IF(LEFT(..), might suffice,
eg in C1:
=IF(LEFT(A1,1)="N",0.15*B1,"")
assuming A1 will contain either "No" or "NA"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to figure the formula 1
how do I search thru the values in my column and replace with nessesary values 1
Formula to return a formula 1
Possible? Variable X and Y data sources and Auto Charting 0
Percentage Formula 3
Formula to display last entry in a column populated with #N/As 4
How do I set up and If statement that does... 1
Substitute a numeric value for a text value in a calculation. 11

Top