+ Reply to Thread
Results 1 to 5 of 5

Nested IF Statements with Blank Cells

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    2010
    Posts
    9

    Nested IF Statements with Blank Cells

    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.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,700

    Re: Nested IF Statements with Blank Cells

    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

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,700

    Re: Nested IF Statements with Blank Cells

    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.

  4. #4
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    2010
    Posts
    9

    Re: Nested IF Statements with Blank Cells

    Thanks, Sambo Kid! It worked. Both options are helpful :-)

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,700

    Re: Nested IF Statements with Blank Cells

    you're welcome, glad that worked for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Multiple If Statements if Cells are Blank
    By SlimPickens in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-04-2017, 12:22 PM
  2. [SOLVED] If Statements and blank cells
    By Nick2512 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2017, 11:35 AM
  3. [SOLVED] Nested If statement, checking multiple cells for Blank cells
    By JLeague in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-30-2015, 11:18 AM
  4. Nested IF Statements for Blank Cell
    By missyboox22 in forum Excel General
    Replies: 3
    Last Post: 01-07-2015, 01:01 PM
  5. Nested If statements. I wanted blank/empty cells to not show 0
    By fleetwood417 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 11:09 AM
  6. Nested IF statements with a range of cells
    By rteeling35 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-08-2013, 05:52 PM
  7. Replies: 12
    Last Post: 05-15-2009, 08:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1