I need help creating a formula that will return a specific value based on two different criteria
I'm trying to create a formula that will return a specific value based on two different criteria.
What I need is to compare a clients age against a specific percent range and return a classification as the result.
for example, if a client is 42 years and has a BAI of 18%, the result of the formula would be "Healthy" as based on the criteria below.
I have a column for the clients age, and another column which calculates the clients BAI percent.
I am trying to avoid a laborious string of IF(AND(xxxxx) statements because that will get messy really quickly. I have entertained a COLLECT / INDEX cross reference, which would probably be easier, but I unsure how I could set that up.
Any ideas, suggestions, etc. would be appreciated. I am also available if someone wants to chat it out with me.
Thanks in advance Smartsheet Community!
Help Article Resources
Check out the Formula Handbook template!