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.

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 07/01/21 Answer ✓


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


    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers