# 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!

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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!!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!