Thread: FALSE value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default FALSE value

Check your other post.

Keyrookie wrote:

Help please,

This formula returns the value I'm looking for =IF(I7="p",G7) in cell
J7 only when I7 has a "p" input. When there is not a p in I7, FALSE
displays in cell J7. How do I get this to work w/o the "FALSE"
showing? I want cell J7 to be blank unless I type p in cell I7.

Confused,
Keyrookie

--
Keyrookie


--

Dave Peterson