Results 1 to 11 of 11

ISERROR to IFERROR

Threaded View

Exequiel3k ISERROR to IFERROR 06-28-2016, 05:50 PM
xlnitwit Re: ISERROR to IFERROR 06-28-2016, 05:54 PM
shirleyxls Re: ISERROR to IFERROR 06-28-2016, 05:57 PM
Exequiel3k Re: ISERROR to IFERROR 06-28-2016, 06:08 PM
Exequiel3k Re: ISERROR to IFERROR 06-29-2016, 12:55 PM
shirleyxls Re: ISERROR to IFERROR 06-29-2016, 01:50 PM
JohnTopley Re: ISERROR to IFERROR 06-29-2016, 01:42 PM
shirleyxls Re: ISERROR to IFERROR 06-29-2016, 01:49 PM
Exequiel3k Re: ISERROR to IFERROR 06-29-2016, 02:24 PM
Jonmo1 Re: ISERROR to IFERROR 06-29-2016, 02:29 PM
Exequiel3k Re: ISERROR to IFERROR 06-29-2016, 04:48 PM
  1. 06-29-2016, 04:48 PM #11
    Exequiel3k is offline
    Forum Contributor
    Join Date
    05-17-2016
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    115

    Re: ISERROR to IFERROR

    Having changed all the IFERROR TO "=IF(XX="","",IF(XXX>XXX*(1-$B$11),1,0))", it was 2.30% slower than ISERROR.

    Essentially, ISERROR faster than "No-Error formula" faster than IFERROR.

    Intresting outcome.. Any thoughts??

    (btw I have a i7 3770 with 8GB ram).
    Last edited by Exequiel3k; 06-30-2016 at 08:19 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. ISERROR/IFERROR With multiple IFS
    By adrianioana in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-14-2016, 12:13 PM
  2. [SOLVED] Adding IFERROR or ISERROR to existing formula when the existing formula returns #VALUE!
    By Hedy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2016, 12:05 PM
  3. Help converting IF(ISERROR to IFERROR
    By npbndcis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-07-2016, 02:37 PM
  4. IFERROR and nested ISERROR with different error messages or non at all
    By metalray in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 11:16 AM
  5. [SOLVED] IF ISERROR instead of IFERROR macro code
    By turist in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2014, 09:41 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. If(iserror function not functioning, but Iserror, and formula stand-alone work fine.
    By cadojib in forum Excel General
    Replies: 1
    Last Post: 12-15-2011, 08:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1