Formula that display < >

R

rlwk

Is there any way to write a formula that will result in the displaying being
the actual symbols < >.
I would like to have 9 years average, then in the 10 year if that is greater
than the average a > symbol would be in that cell, if less than a < symbol
would appear in the cell.
Hope this makes sense.
Thank you for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Based on a Formula 1
Averaging feet and inches (not decimal feet) 4
Use TODAY() function as the criteria in a SUMIF formula 1
Copy addition formula of non-consecutive horizontal cells 2
New to Banter... 1
Conditional formatting for time 2
Conditional formatting using part of the cells contents 3
Need help with a formula 4

Top