I am using a formula that refers to a different sheet, and getting"0" as answer if the reference cell is empty, can someone please help so the cell is empty eg below, if the cell in 'Up to Date'!G2, is empty.
Many thanks in advance
=IF('Up to Date'!$H$2<>"";'Up to Date'!G2;"")