Nested IF statement

[quercus23]

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:

Please Login or Register  to view this content.

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

[se1429]

Hi,

Try this formula:

Please Login or Register  to view this content.

Please check this post on nested IF function:

http://www.exceldigest.com/myblog/20...e-if-function/

Regards.

[quercus23]

Hi,

Try this formula:

Please Login or Register  to view this content.

Please check this post on nested IF function:

http://www.exceldigest.com/myblog/20...e-if-function/

Regards.

Hmmm, I thought that had worked, but, when I now enter a value in J3, it appears to bring up 'No' regardless of whether it is greater or less than H3

[DonkeyOte]

quercus23,

note that:

" " as per se1429 formula is in fact a Space as opposed to a traditional Null value which would be ""

=IF(ISBLANK(J3),"",IF(J3>H3,"Yes","No"))

Also depending on how J3 is populated it may be you'd want to use:

=IF(ISNUMBER(J3),IF(J3>H3,"Yes","No"),"")

[NBVC]

The " " is actually putting a space in the cell... but I think you want to leave it blank (no spaces...no nothing....) because the space may cause you problems later....

Change it slightly to (changing " " to "")

=IF(ISBLANK(J3);"";(IF(J3>H3;"Yes";"No")))

this puts a null and tells excel the cell is blank, not containing any spaces, etc.

[quercus23]

sweet - when I remove the space it sorts the issue!

Thanks again folks - much appreciated