Forum Discussion

Bob_Lac's avatar
Bob_Lac
Copper Contributor
Jan 06, 2021
Solved

Entering symbol into spreadsheet

I am wanting to show a an 'up arrow' or 'down arrow' into a cell depending if one number is higher or lower than another two adjacent cells  
excel
  • Jihad Al-Jarady's avatar
    Jihad Al-Jarady
    Jan 06, 2021

    Bob_Lac 

     


    You would you simple if formula if it is just adding arrow,

    I assume that your data in cells B6, D6, so you can copy the arrow symbols and use them in the formula
    =IF(B6>D6,"▼","▲")

Jihad Al-Jarady's avatar
Jihad Al-Jarady
MCT
Jan 06, 2021

Bob_Lac 

 


You would you simple if formula if it is just adding arrow,

I assume that your data in cells B6, D6, so you can copy the arrow symbols and use them in the formula
=IF(B6>D6,"▼","▲")

  • Bob_Lac's avatar
    Bob_Lac
    Copper Contributor
    Jan 06, 2021

    Jihad Al-Jarady 

     

    That was what I wanted. It is working perfectly, Thank you very much

Resources