Return a specific value if between a range
I have a sheet in which several questions are asked, and depending on the answers then different scores are returned. There are seven questions, and I sum those in a column called [Imposed Risk Score]. From that total, I need it to report back a risk tolerance if the score falls between a range.
21-40: Moderately Conservative
61-80: Moderately Aggressive
81-100: Aggressive Growth
I can't seem to get my nested IF statements correct and the only examples I can find online don't show how to do this for multiple ranges. The only other examples I can find are vlookup and I want to avoid having another sheet that has the ranges and return values listed if possible.
Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!