If then formula help

Brittany Graves

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!

Paul Newcome

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"))

Paul Newcome

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"))

Brittany Graves

Thank you Paul!!

Paul Newcome

Happy to help. 👍️