Results 1 to 4 of 4

Nesting IF statements

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-13-2009
    Location
    Lincoln, IL
    MS-Off Ver
    365
    Posts
    242

    Question Nesting IF statements

    I'm trying to nest if statements that also include "and" and "isblank" factors. The following formula isn't working, and I'm not sure if it's because of my use of isblank or lack/placement of parentheses.

    =if(and($h$10<>0,$i$10<>0),index(JointTable2008,Match($h$10,Spouse1,0),Match($i$10,Spouse2,0)), if(and($h$10<>0,(isblank($i$10)),index(SingleTable2008,Match($h$10,Single,0)), if(and($i$10<>0,(isblank($h$10)),index(SingleTable2008,Match($i$10,Single,0)), if(and(isblank($h$10),($i$10)),”Not applicable”,”ERROR”)
    I'm sure I don't have enough parentheses at the very end, but not sure what else is wrong.
    Last edited by narrowgate88; 06-02-2009 at 03:03 PM.

Thread Information

Users Browsing this Thread

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

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