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
 
Have you looked at the examples given in Excel help for the IF function?
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"False" 3
The "IF" Statement 1
nested if statements using "AND" as well as "OR" 2
IF Statement 1
keep old cell value and new cell value 2
How do I ??? - two drop down lists 3
If condition to find Target 2
help with formula 4

Back
Top