Try this

=IF('[Scorecard test export.xls]Scorecard Final Query
Table'!$A$2="AEAL",IF(OR('[Scorecard test export.xls]Scorecard Final Query
Table'!$B$52="",'[Scorecard test export.xls]Scorecard Final Query
Table'!$B$52=0),"",'[Scorecard test export.xls]Scorecard Final Query
Table'!$B$52),"")

I have included if cell B52 = 0, it will also return a blank
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

I am an ordinary user trying to assist another

Thank You

cheers, francis



"Jeremy" wrote:

Example of what I am working with

=IF('[Scorecard test export.xls]Scorecard Final Query
Table'!$A$2="AEAL",'[Scorecard test export.xls]Scorecard Final Query
Table'!B52,"")

I want this formula to leave the cell blank if the condition is false. My
goal is to eliminate any zeros from the sheet?

can someone please enlighten?