Amend ‘If – And ‘formula for another condition

[robertguy]

Hi, can anyone please advise me of the syntax required to amend the following code

Please Login or Register  to view this content.

=IF(AND(I4>=$H2,I4<=$I2),"For This Period","Not In This Period")

Please Login or Register  to view this content.

to also check if I4 is blank and if so to return a blank field i.e. no text as opposed to returning either "For This Period" or "Not In This Period")

Many thanks in advance Rob
N.B. I have attached an example workbook

[BadlySpelledBuoy]

Please Login or Register  to view this content.

BSB

[robertguy]

BSB

EXCELLENT - Many thanks for your 'VERY' prompt reply, it works a treat !

Many thanks

Rob

[BadlySpelledBuoy]

No problem, Rob. Happy to help.

Thanks for the rep point.

BSB