FALSE value

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
 
F

Franz Verga

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
 
D

Dave Peterson

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...
 

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
nested if statements using "AND" as well as "OR" 3
If condition to find Target 1
keep old cell value and new cell value 2
help with formula 4
Combination to Two formulas with the Help of AND / OR / IF Functions 1
The "IF" Statement 1
TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked 1

Top