Results 1 to 6 of 6

Nested ISERROR?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-17-2009
    Location
    West Midlands
    MS-Off Ver
    Excel 2016
    Posts
    213

    Nested ISERROR?

    Hi all

    I don't think you can nest IFERROR, unfortunately, so here's what I'm trying to do:

    A B C
    1 54.6 #N/A #N/A
    2 #N/A 44.1 #N/A
    3 #N/A #N/A 78.9

    IF there is a value in column A return that value, however, if there is an error, return the value in column B. Additionally if there are errors in both columns A AND B return the value in column C.

    Any ideas?

    SA
    Last edited by SAsplin; 03-09-2012 at 07:53 AM.

Thread Information

Users Browsing this Thread

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

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