Symbol to reflect variance from previous day

Kristie Diersen

I am trying to create a formula where If the number from today is equal to the previous day, then the symbol will be yellow arrow, if it is less than the day before, it will be a green arrow and if it is greater than the day before, the arrow will be red. Any ideas?

Tomasz Giba

Hi @Kristie Diersen

If I understood you correctly then the formula will be:

=IF(Previous@row = Today@row, "Sideways", IF(Previous@row > Today@row, "Up", "Down"))