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
Last edited by 8krungirl; 11-09-2018 at 02:43 PM.
not working now that I can test it. will retry.
Last edited by Sam Capricci; 11-09-2018 at 03:13 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
ok, pointed the original at the wrong cells, this works...
=IF(AND(B2<>"",C2=""),"No longer Ranked",IF(AND(B2="",C2<>""),"New to Ranking",IF(B2<C2,"Decrease",IF(B2>C2,"Increase",IF(B2=C2,"No Change",IF(AND(A2<>"",B2=""),"No longer Ranked",""))))))
EDIT: and if you want it blank when nothing is in col A then just use this
=IF(A2="",""IF(AND(B2<>"",C2=""),"No longer Ranked",IF(AND(B2="",C2<>""),"New to Ranking",IF(B2<C2,"Decrease",IF(B2>C2,"Increase",IF(B2=C2,"No Change",IF(AND(A2<>"",B2=""),"No longer Ranked")))))))
Last edited by Sam Capricci; 11-09-2018 at 03:18 PM.
Thanks, Sambo Kid! It worked. Both options are helpful :-)
you're welcome, glad that worked for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks