Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Location
    Washington, District Of Columbia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Nested Function Returning False (2000)

    Hello!

    I have the following formula in one column of my worksheet. In one P1'!F_ cell, I have a value of 0. The formula returns "false." My intent is that it returns a value of 0 if P1'F_ is 0 (and separate values if it is greater than 0). Can anyone detect the error in the function? Note: P1 and P3 are separate worksheets.

    =IF('P1'!F5>0,IF(A5=1,'P3 Intermediate'!$Y$2,IF(A5=2,'P3 Intermediate'!$Y$3,IF(A5=3,'P3 Intermediate'!$Y$4,IF(A5=4,'P3 Intermediate'!$Y$5,IF(A5=5,'P3 Intermediate'!$Y$6,0))))))

    Thank you,

  2. #2
    New Lounger
    Join Date
    Jul 2003
    Location
    Washington, District Of Columbia
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nested Function Returning False (2000)

    Thank you again, Hans. [img]/forums/images/smilies/smile.gif[/img]

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Nested Function Returning False (2000)

    (Second formula edited because I forgot the "Else" part originally.)

    The first IF doesn't have an "else" part. Try

    =IF('P1'!F5>0,IF(A5=1,'P3 Intermediate'!$Y$2,IF(A5=2,'P3 Intermediate'!$Y$3,IF(A5=3,'P3 Intermediate'!$Y$4,IF(A5=4,'P3 Intermediate'!$Y$5,IF(A5=5,'P3 Intermediate'!$Y$6,0))))),0)

    You could also try this formula:<pre>=IF('P1'!F5>0,INDIRECT("'P3 Intermediate'!$Y$"&A5,0),0)</pre>

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •