Results 1 to 6 of 6

Nested IF statement

Threaded View

quercus23 Nested IF statement 02-05-2009, 05:48 AM
se1429 Re: Nested IF statement 02-05-2009, 07:37 AM
quercus23 Re: Nested IF statement 02-05-2009, 09:17 AM
DonkeyOte Re: Nested IF statement 02-05-2009, 09:25 AM
NBVC Re: Nested IF statement 02-05-2009, 09:26 AM
quercus23 Re: Nested IF statement 02-05-2009, 09:28 AM
  1. #1
    Registered User
    Join Date
    02-05-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Nested IF statement

    Hello all,

    Thi is my first post so hello to all and thank you for reading!

    Basically, I have a spreadsheet which features dates. If the second date (J3) is greater than the first date (H3), then I would like the third cell (named 'deduction' to show 'Yes', otherwise, the deduction cell should show 'No'. This bit I have no problem with and I have used the following formula:

    =IF(J3>H3, "Yes", "No")
    However, when I drag the 'deduction' formula down the column, where there is no date in column J, the 'deduction' cell displays 'No'. However, where there is no date in column J I would like the 'deduction' cell to remain blank.

    I think this can be resolved by adding and 'AND' into the if statement, but can't quite work it out. Any suggestions muchly appreciated.

    Hope that makes sense!

    Quercus
    Last edited by quercus23; 02-05-2009 at 09:28 AM.

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