If then formula help
I have a column , Average Score, that has been calculated using other fields. I want to use the average score to determine if an initiative is a program or project. If the initiative’s average score is between: 5 and 9 it is considered a project and if the score is between 10 and 15, it is considered a program. I need a formula that will use that to state if it is program or project based off the average score into the cell of initiative type. Please help!
Help Article Resources
Check out the Formula Handbook template!