+ Reply to Thread
Results 1 to 6 of 6

Need formula: IF statements to return three possible values(Increase, Decrease, No change)

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    67

    Exclamation Need formula: IF statements to return three possible values(Increase, Decrease, No change)

    I have a spreadsheet in Excel 2010 that contains Column A and Column B. Column A is Percentage Decrease. Column B is Percentage increase. I need a column C to return the value "Increase," "Decrease" or "No change" when comparing the two columns.

    Example:

    A-Percentage Decrease B Percentage Increase C Net Impact
    10% 20% Increase
    40% 30% Decrease
    50% 50% No change

    What formula would I insert in Column C to return these values?

    Currently, I have the formula: =IF(A>B, "Decrease," "Increase")

    This returns correct "Increase" and "Decrease" values, but of course does not return "No change" values. (It returns A = B as "Decrease).

    Thanks for your help!

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need formula: IF statements to return three possible values(Increase, Decrease, No cha

    Hi and welcome to the forum

    Try this formula

    =IF(A1=B1,"No Change",IF(A1>B1,"Decrease","Increase"))
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need formula: IF statements to return three possible values(Increase, Decrease, No cha

    Try

    =IF(A1>B1,"Increase",IF(A1<B1,"Decrease","No Change"))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    02-03-2014
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Need formula: IF statements to return three possible values(Increase, Decrease, No cha

    Yes!! That worked :-) Thanks!

    Addendum: Some fields have "N/A" or blanks for fields, as we don't have the information. Those return "equals" when I use this formula. Is there a way to make the return value for column C "N/A" in this instance?

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need formula: IF statements to return three possible values(Increase, Decrease, No cha

    Try this

    =IF(OR(A1="",B1=""),"N/A",IF(A1=B1,"No Change",IF(A1>B1,"Decrease","Increase")))

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need formula: IF statements to return three possible values(Increase, Decrease, No cha

    You're welcome and thank you for your feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. Percentage Increase/Decrease formula for all values including 0
    By loz2289 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2012, 12:16 PM
  2. Replies: 3
    Last Post: 09-18-2012, 01:01 AM
  3. Replies: 1
    Last Post: 06-22-2010, 11:14 AM
  4. Nested IF statements to calculate increase / decrease
    By silkscreen in forum Excel General
    Replies: 2
    Last Post: 03-27-2010, 05:46 AM
  5. How to increase/decrease values individually?
    By gergerger in forum Excel General
    Replies: 2
    Last Post: 10-13-2008, 02:01 PM

Tags for this Thread

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