Thread: returning blank cell in an if statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeremy Jeremy is offline
external usenet poster
  
Posts: 184
Default 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?

Reply With QuoteReply With Quote