Results 1 to 3 of 3

INDIRECT Formula used to work but now it isn't..

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2019
    Location
    Sydney
    MS-Off Ver
    365 for Business
    Posts
    2

    INDIRECT Formula used to work but now it isn't..

    Hello,

    I have a formula that used to work. It would work out the date of a task whether or not it has a dependency on another task or not and act accordingly with INDIRECT. It is below:

    =IF($J12="Yes",IF(INDIRECT("O"&I12+9)="","",IF(I12<>"",WORKDAY(INDIRECT("O"&I12+9),1),K12)),IF(INDIRECT("N"&I12+9)="","",IF(I12<>"",WORKDAY(INDIRECT("N"&I12+9),1),K12)))

    The problem is that when I12 returns "", M12 (which has this formula) still won't return the date from K12.

    This has me scratching my head hard as it was working before and now it is not. Any help would be great, thanks!

    Link to the file:
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Indirect function causing formula not to work
    By JohnDoh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2015, 11:48 AM
  2. Replies: 6
    Last Post: 10-22-2014, 09:07 AM
  3. [SOLVED] ERROR ALERT on INDIRECT formula won't work
    By vio.coman in forum Excel General
    Replies: 2
    Last Post: 10-08-2014, 06:12 AM
  4. ERROR ALERT on INDIRECT formula won't work
    By vio.coman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2014, 05:16 AM
  5. [SOLVED] Indirect formula doesn't work
    By Ztv in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2014, 05:15 PM
  6. [SOLVED] Will an INDIRECT formula combined with a VLOOKUP work?
    By DRFJR in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-02-2014, 09:03 AM
  7. Replies: 1
    Last Post: 02-28-2012, 02:55 AM

Tags for this Thread

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