Hello, I am trying to get results for "Rank Change". I am able to get results using IF(B2<C2,"Decrease",IF(B2>C2,"Increase",IF(B2=C2,"No Change"))) if there are numbers in the cells. However, I am having trouble if there are "blanks".
IF Statement.PNG
Beverage 2017 Rank 2018 Rank Rank Change
Coke 1 2 Decrease
Pepsi 2 3 Decrease
Sprite 3 4 Decrease
Starbucks 4 1 Increase
Dasani 5 5 No Change
Canada Dry 6 BLANK No longer ranked
Fanta BLANK 6 New to Ranking
Bookmarks