Symbol formulas

Justin Mauzy

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.

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:

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

=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:

Justin Mauzy

That worked perfectly. Thank you!

Bassam Khalil

@Justin Mauzy

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