If then formula help
Hi All!
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!
Best Answer

You would use something like this:
=IF(AND([Average Score]@row>= 5, [Average Score]@row<= 9), "Project", IF(AND([Average Score]@row>= 10, [Average Score]@row<= 15), "Program"))
Answers

You would use something like this:
=IF(AND([Average Score]@row>= 5, [Average Score]@row<= 9), "Project", IF(AND([Average Score]@row>= 10, [Average Score]@row<= 15), "Program"))

Thank you Paul!!

Help Article Resources
Categories
Check out the Formula Handbook template!