Average formula with an IF statement

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?

Find more posts tagged with

Accepted answers

Carson Penticuff

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

jamiefico

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

All comments

Carson Penticuff

There sure is!

jamiefico

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.