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
"Keyrookie" ha scritto nel messaggio
...

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

Franz,

Thanks! It worked exactly like I'd hoped. I have macro puzzler... I want to paste copied text into a cell and have the macro copy and paste the value of the cell directly to the left of the cell I just pasted into. in other words, I am pasting copied text into cell C9. I have cell B9 formated for NOW() and I want the macro to copy cell B9 and paste the value back into B9 when I paste into cell C9. Any ideas on how make this happen?

Keyrookie

Have you looked at the examples given in Excel help for the IF function?
--
David Biddulph

"Keyrookie" wrote in message
...

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

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