+ Reply to Thread
Results 1 to 3 of 3

Having trouble building a compound IF formula

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    Graniteville,SC
    MS-Off Ver
    Excel 2007
    Posts
    16

    Having trouble building a compound IF formula

    Book0.5 template.xlsx

    I have been trying to create an IF formula to post the next lab draw date based on several criteria. I can get both halves to work correctly, but when I place then together it does not carry through the whole formula, it stops after the first two calculations either way I write it. I have an initial treatment, 30 days after the treatment I need blood work done, I also need blood work done 3 mths after treatment, and I need to follow the patient every 6 mths after that with blood work. Ideally, when I input the last blood draw it will post to either the 1 mth or 3 mth columns automatically depending if they have been done and these calculations performed so I can schedule things. But right now I will settle for this formula if anyone could help. Thanks.

    I have: Col G (1 Mth draw) Col J (3 mth draw) Col L (Initial Tx) Col N (Last blood Draw) and Col O (Next blood draw and cell for the formula); I am working in row 4.

    My formula is: IF(G4=0,L4+30,IF(G4>0,G4+60,IF(J4>G4,J4+180,IF(N4>J4,N$+180,J4+180))))

    Any help would be appreciated

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Having trouble building a compound IF formula

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    01-02-2014
    Location
    Graniteville,SC
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Having trouble building a compound IF formula

    Sorry arlu1201, you are completely correct....

    I ended up adding in the and function into my equation and after several hours realized that I had to make my arguments more relative to eachother. The AND fx worked great and the formula looked like this:

    =IF(A4=0,"",IF(G4=0,L4+30,IF(AND(G4>0,J4=0),G4+60,IF(AND(J4>0,N4=0),J4+180,N4+180))))

+ 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. building a revenue forecasting model and need calendar building help
    By miken33 in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 03-11-2013, 06:53 PM
  2. Replies: 2
    Last Post: 10-08-2012, 12:49 PM
  3. Compound interest formula
    By Meechy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2012, 08:00 PM
  4. Replies: 6
    Last Post: 12-29-2011, 04:06 PM
  5. compound interest formula
    By Ciara in forum Excel General
    Replies: 3
    Last Post: 06-08-2005, 11:05 AM

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