If functions and formula HELP!

Options

if cell a is averaging from 3 to 3.99 then cell b is equal to "Satisfactory"

if cell a is averaging from 4.0 to 4.99 then cell b is equal to "Very Satisfactory"

if cell a has average of 5.0 then cell b is equal to "Outstanding"

3.00 to 3.99 = Satisfactory

4.0 to 4.99 = Very Satisfactory

5.0 = Outstanding

Thank you for helping in advance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!