returning blank cell in an if statement
 

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?

returning blank cell in an if statement
 

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?

returning blank cell in an if statement
 

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,"")


"Jeremy" wrote in message
...
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?