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