+ Reply to Thread
Results 1 to 5 of 5

% Increase Formula using IFERROR

  1. #1
    Registered User
    Join Date
    05-09-2018
    Location
    Fort Lauderdale
    MS-Off Ver
    2016
    Posts
    13

    Exclamation % Increase Formula using IFERROR

    Can the formula (A2/A1)-1 use IFERROR? I can't seem to get it to work after multiple attempts. I receive the error not enough arguments.

    I am trying to convert #DIV/0! to 100

    Thanks!

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,584

    Re: % Increase Formula using IFERROR

    This is a guess.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If this doesn't do what you want we are going to need some sample BEFORE and AFTER data ... perhaps an uploaded representative Excel workbook.

    If you are not familiar with how to do this (the paperclip icon does not work ):


    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
    • be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”

    The file name will appear at the bottom of your reply.
    Dave

  3. #3
    Registered User
    Join Date
    05-09-2018
    Location
    Fort Lauderdale
    MS-Off Ver
    2016
    Posts
    13

    Re: % Increase Formula using IFERROR

    I tried and didn't work.

    I tried to attach an image (sorry, but using VLOOKUP and would require changing too much data and the data is confidential) so hopefully worked.
    Basically first columns use VLOOKUP formula and then last 3 columns use the % change formula (A2/A1)-1
    Attached Images Attached Images

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,395

    Re: % Increase Formula using IFERROR

    We do not need to see all of your data, just a desensitised sample. Please attach a workbook - the image is of no help at all.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,700

    Re: % Increase Formula using IFERROR

    IFERROR worked for me...
    U
    6
    972
    7
    0
    8

    U8=IFERROR(U6/U7-1,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] If/Then Formula of IFERROR
    By sclinger13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2017, 03:31 AM
  2. [SOLVED] Want to add IFERROR in my formula
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2017, 03:36 AM
  3. [SOLVED] Multiple IFERROR or IFERROR w/ If Statements
    By SanchoPanza1 in forum Excel General
    Replies: 4
    Last Post: 03-31-2016, 08:09 PM
  4. [SOLVED] IFERROR(MATCH & IFERROR(SMALL Help Needed
    By chad328 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-17-2016, 06:34 AM
  5. Iferror or other formula
    By sarahqputra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2015, 07:31 AM
  6. xlfn.IFERROR or IFERROR don't work in Excel 98-2003
    By dj_danu01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 02:53 AM
  7. [SOLVED] #DIV/0 IFERROR formula
    By rlkerr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 10:33 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