Hi, can anyone please advise me of the syntax required to amend the following code
=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")![]()
Please Login or Register to view this content.
Many thanks in advance Rob
N.B. I have attached an example workbook
Bookmarks