+ Reply to Thread
Results 1 to 4 of 4

how to wrap iferror in my if statement in a table

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    how to wrap iferror in my if statement in a table

    i have a table that i have the following formula:

    =IF([@LTC]-B2=0,"No Change",IF([@LTC]-B2<0,"Red","Green"))

    i would like to wrap this in an iferror clause, basically if @LTC-B2=error then write "No Data", otherwise process the if statement.

    how can that be done?

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: how to wrap iferror in my if statement in a table

    In cases where [@LTC]-B2 produces an error, does the entire formula produce an error?

    If so, you can do this:

    =IFERROR(IF([@LTC]-B2=0,"No Change",IF([@LTC]-B2<0,"Red","Green")),"")

  3. #3
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,518

    Re: how to wrap iferror in my if statement in a table

    thanks @63falcondude for that. exactly what i was looking for. thread is solved.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: how to wrap iferror in my if statement in a table

    You're welcome. Thanks for the rep!

+ 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. Create Custom Menu to wrap Selected Cells in IFERROR formula
    By mr_newbie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2016, 10:17 AM
  2. Please help with and IF statement including IFERROR
    By justinr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-28-2015, 06:21 PM
  3. [SOLVED] Please help with an IF statement including IFERROR
    By justinr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2015, 05:47 PM
  4. IFERROR Statement Help/Update...
    By kzemaitis in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-18-2014, 06:32 PM
  5. [SOLVED] Trying to wrap a nested if(vlookup) statement in an IFerror
    By Groovicles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2014, 01:00 PM
  6. [SOLVED] IFERROR Statement in VBA for date
    By Maxy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-11-2013, 08:44 AM
  7. Help modifying macro to wrap iferror formulas around existing formulas
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:04 PM

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