Thread: returning blank cells in an IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default returning blank cells in an IF function
=IF(TODAY()=A6,C6-B6,"")

Vaya con Dios,
Chuck, CABGx3


"Squeky" wrote in message
...
I have a function which reads =IF(TODAY()=A6,C6-B6,"Blank")

I am trying to have it return an empty cell if the statement is false and
I
can't find to right keyword.


Reply With QuoteReply With Quote