Results 1 to 7 of 7

writing a recursive function

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    24

    writing a recursive function

    So I have this function...
    =IF('Equipment List'!N2=TRUE,'Equipment List'!A2,"-")
    and now instead of displaying "-" when it fails, I want it to check the next item in the list, 'Equipment List'!N3 and display it, A3.

    Now what I can't figure out is that if N3 also fails, how can I get it to keep moving down the list till it finds an item to display or reaches the end?
    Last edited by rmoney; 07-19-2010 at 03:00 PM.

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