Risk Profiler

rparedes

New Member
Joined
Sep 11, 2018
Messages
12
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

theBardd

Rules violation
Joined
Jan 21, 2012
Messages
912
This array formula should do it for you

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

Watch MrExcel Video

Forum statistics

Threads
1,102,455
Messages
5,486,998
Members
407,575
Latest member
calc

This Week's Hot Topics

Top