Thread: I want to hide values if no data in target cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
  
Posts: 341
Default I want to hide values if no data in target cell
in A2, use

=IF(A1="","",A1)

--
Allllen


"Steve" wrote:

I'm am using an IF function. I'm typing data in A1 and my IF function value
is in A2. This function is using A1 do determine the value of cell A2. I
don't want values displayed in A2 unless there is data in A1.
Reply With QuoteReply With Quote