+ Reply to Thread
Results 1 to 6 of 6

Add criteria to existing % Change formula

  1. #1
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Add criteria to existing % Change formula

    Hi guys, its probably a very simple one for an expert, but I seems to keep getting error results, or formula just isn't working. Attaching a screenshot and EXCEL file itself. Can you help add additional criteria to existing formula, please? Thank you!

    https://www.excelforum.com/attachmen...1&d=1505574808

    https://www.excelforum.com/attachmen...1&d=1505574825 <-- EXCEL
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Add criteria to existing % Change formula

    See F9 in attached..
    vill-add-criteria-to-existing-change-formula-percent-change.xlsx
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Add criteria to existing % Change formula

    Thank you so much!!! Formula works, only issue I'm currently experiencing is that if E9=0 or E9 is "-", would still like to see blank in F9.... is this possible to achieve? Re-attaching a file with just this one issue.

    Thank you, once again!!

    https://www.excelforum.com/attachmen...1&d=1505578951

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Add criteria to existing % Change formula

    You're welcome. Sorry, I forgot to address the blank part from your first post. Try this formula in F9
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Add criteria to existing % Change formula

    Ahh, wonderful! Worked, beautifully, thank you!!!! Have a nice day!

  6. #6
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Add criteria to existing % Change formula

    You're welcome. Thank you for the rep and have a nice day as well.

+ 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] need a formula for increase % between criteria with my existing data
    By santosh226001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2017, 01:40 AM
  2. [SOLVED] Change existing formula
    By dekueb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2017, 03:58 AM
  3. [SOLVED] how to add a filter criteria to an existing array formula?
    By da.se in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2017, 10:40 PM
  4. Replies: 7
    Last Post: 07-07-2014, 09:48 AM
  5. [SOLVED] need to add additional criteria to existing formula
    By Mattr177 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2014, 12:12 AM
  6. [SOLVED] Formula for line numbers to change with existing formula
    By Vmgballer1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 09:36 AM
  7. Need to change existing formula into values...
    By Sriram in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2006, 11:35 AM

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