SOLVED

Entering symbol into spreadsheet

Copper Contributor

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

 

4 Replies

Hi @Bob_Lac 

 

You would use the conditional format

Home tab --> click on Conditional format on the style group

best response confirmed by Bob_Lac (Copper Contributor)
Solution

@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 

 

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

@Bob_Lac 

You are welcome,

1 best response

Accepted Solutions
best response confirmed by Bob_Lac (Copper Contributor)
Solution

@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,"▼","▲")

View solution in original post