Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning blank when reference cell is blank | Excel Worksheet Functions | |||
IF statement not returning a blank so a chart line won't gap | Charts and Charting in Excel | |||
"If" statement returning blank gives downstream formula errors. | Excel Discussion (Misc queries) | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
returning blank cell | Excel Worksheet Functions |