# Thread: Understanding an IF (XL2K SR1)

1. ## Understanding an IF (XL2K SR1)

I am a little slow in my old age... I received a workbook that has a formula in one of the cells that bascially says..
IF(ISNA(E9),FALSE, TRUE)
Is the formula really saying that look at the value in E9 to see if it is #N/A and if it is (the FALSE portion) then say it isn't or if it isn't (the TRUE portion) leave it alone?

TIA

Dennis

<img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>

2. ## Re: Understanding an IF (XL2K SR1)

It looks at the value of E9. If E9 returns an error value #N/A, then it returns an output of FALSE (the if true argument). If E9 is not an error of N/A, then it returns TRUE (the ifs False argument)

3. ## Re: Understanding an IF (XL2K SR1)

This formula returns FALSE is the value of E9 is #N/A, and TRUE if the value of E9 is something else. It is equivalent to the shorter formula

=NOT(ISNA(E9))

#### Posting Permissions

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