Risk Profiler

[rparedes]

Hi, I doing investment risk profiler in excel. Basically, what I want to achieve is that each letter on the questions corresponds to a number and based on the user's choice it will add up on the analysis box. The score then will be evaluated as aggressive, low risk, or mid risk. My question is

1. How can I assign a value on each letter of each questions?

I attached the copy of my excel file

Thanks,

https://www.dropbox.com/s/esuhhruq1oqif60/Financial Worksheet (latest).xlsx?dl=0

 

[sandy666]

file is not shared

have a nice day

 

[theBardd]

This array formula should do it for you

=SUM(IFERROR(CODE(B1:B52)-64,0))