Symbol formulas

I want to compare 2 cells and depending on the results, display a different symbols.

I have a column called Average Time. There are 2 cells, one for Q2 and one for Q3. If the average time in Q2 is less than Q3 I want to display an Up arrow, if it is the same a Dash and if it is greater, the Down arrow.

Thanks in advance for the help.

Find more posts tagged with

Accepted answers

Bassam Khalil

@Justin Mauzy

Please try the following formula

=IFERROR(IF([Call Average Time]7 - [Call Average Time]14 > 0, "Up", IF([Call Average Time]7 - [Call Average Time]14 < 0, "Down", IF([Call Average Time]7 - [Call Average Time]14 = 0, "Unchanged"))), "")

screenhots shows the result:

All comments

Bassam Khalil

Hi @Justin Mauzy

Hope you are fine, Could you please share a screenshot for your sheet after removing any sensitive data

Justin Mauzy

Here is a screenshot:

So, what I want it to do is:

If the total time in the column Call Average Time on row 7 (Q2) is greater than the total time on line 14 (Q3), I want to automatically have the Green UP arrow show in row 1.
If the total time in the column Call Average Time on row 7 (Q2) is less than the total time on line 14 (Q3), I want to automatically have the Red DOWN arrow show in row 1.
If the total time in the column Call Average Time on row 7 (Q2) is equal to the total time on line 14 (Q3), I want to automatically have the Yellow dash show in row 1.
The Symbols: column is set to the Symbols... type (shown below).

Thank you,

Bassam Khalil

@Justin Mauzy

Please try the following formula

screenhots shows the result:

Justin Mauzy

That worked perfectly. Thank you!

Bassam Khalil

@Justin Mauzy

You are welcome and I will be happy to help you any time.

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.