returning blank cell in an if statement

[Jeremy]

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?

 

[francis]

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

 

[Bassman62]

Try this:
=IF(EXACT('[Scorecard test export.xls]Scorecard Final Query
Table'!$A$2,"AEAL"),'[Scorecard test export.xls]Scorecard Final Query
Table'!B52,"")
The text is case sensitive and must match exactly.

If you want to use upper or lower case try:
=IF(CELL("CONTENTS",'[Scorecard test export.xls]Scorecard Final Query
Table'!$A$2)="AEAL"),'[Scorecard test export.xls]Scorecard Final Query
Table'!B52,"")