# Average formula with an IF statement

Options
edited 04/12/24

I have this average formula in a sheet based on 4 columns: =AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row)

The results would be either 1,2,3, or 4. I'd like to translate the resulting number into text. For example, let's say my average formula equals 2. Instead of showing "2" in the cell it would say "Medium". Is there a way to add an IF statement as such to this formula?

• ✭✭✭✭✭✭
Options

There sure is!

=IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 1, "Almost Medium", IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 2, "Medium", IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 3, "Extra Medium", IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 4, "Super Extra Medium", ""))))

Options

Worked beautifully, thank you! Especially so quick on a Friday afternoon, appreciate it very much!

• ✭✭✭✭✭✭
Options

There sure is!

=IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 1, "Almost Medium", IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 2, "Medium", IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 3, "Extra Medium", IF(AVG(Duration@row, [Existing Technical Knowledge]@row, [Technical Complexity]@row, [Testing Effort]@row, [OCM Effort]@row) = 4, "Super Extra Medium", ""))))