FALSE value

  • Thread starter Thread starter Keyrookie
  • Start date Start date
K

Keyrookie

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
 
Hi Keyrookie,

try this way:

=IF(I7="p",G7,"")

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy
 
Check your other post.
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
Click to expand...
 
Back
Top