Month over Month Increase or Decrease

[taudano]

I am missing one set of criteria I cannot figure out in the formula below. I am working on a method to indicate whether a core keyword rank in search engines has increased, decreased or remained same month over month.

=IF(AND(CV7<DJ7),"#",IF(AND(CV7>DJ7),"$",IF(AND(CV7=DJ7)," ")))

CV7 = May rank and DJ7 = April rank

I am using wingdings3 font to show:
- Up arrow (#) if CV7 (May rank) is lower than DJ7 (April rank)
- Down arrow ($) if CV7 (May rank) is higher than DJ7 (April Rank)
- If CV7 and DJ7 are equal value, a blank cell (or a space, " ")

The part I cannot figure out is if DJ7 (April rank) is blank, but CV7 (May rank) has a value, I want to show an up arrow. Any ideas of how to add that to this formula?

 

[Jerry Sullivan]

The part I cannot figure out is if DJ7 (April rank) is blank, but CV7 (May rank) has a value, I want to show an up arrow. Any ideas of how to add that to this formula?

This should work...

=IF(OR(CV7="",DJ7 < CV7),"#",IF(DJ7>CV7,"$",""))

FYI. The formula you posted is probably not displaying what you intended. When posting a "less than" < symbol on this board, you need to put spaces around it or it is interpreted as a special character.

 

[taudano]

Thank you Jerry! Good to know about special characters and how they display on this board.