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:
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.![]()
=IF(J3>H3, "Yes", "No")
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
Bookmarks