Blank Cell Instead of "False" in this formula

[Pandora867]

Hello -

I am trying to streamline some reporting for work and need to verify a positive of negative improvement from week to week within the same document. Each week has it's own sheet with it's own set of data that is populated from in the field each week.
How can I make sure the cell remains blank until the current week's data is entered, instead of a return of "False" in this statement?

=IF(AND('Week 45'!M2<>"", 'Week 46'!M2<>""), 'Week 46'!M2-'Week 45'!M2), ""

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(AND('Week 45'!M2<>"", 'Week 46'!M2<>""), 'Week 46'!M2-'Week 45'!M2, "")