# Thread: Nested Function Returning False (2000)

1. ## 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. ## Re: Nested Function Returning False (2000)

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

3. ## 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
•