Thread: Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
insitedge insitedge is offline
external usenet poster
  
Posts: 7
Default Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell
In a cell, I often want to reference another cell and want to return
"No value" or have it remain Blank, but the cell that I am referencing
has a formula, so ISBLANK does not interpret that the referenced Cell
is Blank. What formula can I use to return no value or leave the cell
blank even though the referenced cell has a formula?

Jim,
Denver
Reply With QuoteReply With Quote