Thread: Returning "blank" when first cell is blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Returning "blank" when first cell is blank
Info only

You don't need the =TRUE

=if(isblank('Performance Analysis'!A5),"",'Performance Analysis'!A5)


Gord Dibben MS Excel MVP


On Wed, 28 Oct 2009 11:23:01 -0700, cm wrote:

try this:

=if(isblank('Performance Analysis'!A5)=TRUE,"",'Performance Analysis'!A5)

Reply With QuoteReply With Quote