+ Reply to Thread
Results 1 to 2 of 2

Help with nested if statements...

  1. #1
    Registered User
    Join Date
    05-21-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Help with nested if statements...

    Hi, I'm having problems getting a formula to work.

    It is>

    =IF(I2=J2,I2+1,IF(AND(I2>0,ISNA(J2)),I2+1,IF(AND(ISNA(I2),J2>0),J2+1,"none")))

    The first part is working fine, if I2 and J2 are the same, I am getting I2+1, if not, i'm getting #N/A. For some background, if there are numbers in both I2 and J2 they will always be the same, if there is no number, there will be #N/A (caused by another formula), if there is a number it will always be higher than 0.

    Thanks in advance for your help, I've scratching my head over this all morning, and I know i'm probably just doing something stupid...

    Cheers

    Elliott

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Help with nested if statements...

    Perhaps:

    =IF(COUNT(I2:J2),1+IF(ISNUMBER(I2),I2,J2),"none")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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