| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a formula to calculate a letter as a value
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set up a formula to calculate a letter as a value
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" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jk101133" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
| Formula won't calculate... | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
Linear Mode
