Hello Folks,

I need a little help with what I think is a simply problem, but it is
over my head.

I need a formula that will multiply to cells when an x is placed in
another cell.

I would like a formula in cell H20, that when someone places an X or x
in cell C20, multiply cell D20 by cell F20, with the answer in H20.

Thanks for you time!

Jess

Jess, put this in H20 , =IF(C20="x",D20*F20,"")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jess" wrote in message
...

Hello Folks,

I need a little help with what I think is a simply problem, but it is
over my head.

I need a formula that will multiply to cells when an x is placed in
another cell.

I would like a formula in cell H20, that when someone places an X or x
in cell C20, multiply cell D20 by cell F20, with the answer in H20.

Thanks for you time!

Jess

=IF(C20="X",D20*F20,"")

put that in H20


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Jess" wrote in message
...

Hello Folks,

I need a little help with what I think is a simply problem, but it is
over my head.

I need a formula that will multiply to cells when an x is placed in
another cell.

I would like a formula in cell H20, that when someone places an X or x
in cell C20, multiply cell D20 by cell F20, with the answer in H20.

Thanks for you time!

Jess

Jess

Entered in H20................

=IF(C20="x",D20*F20,"no x in C20")

You don't say what you want done if there is no x in C20, so I added the text.

Adjust to suit.


Gord Dibben MS Excel MVP


On Thu, 13 Apr 2006 15:56:30 -0500, Jess wrote:


Hello Folks,

I need a little help with what I think is a simply problem, but it is
over my head.

I need a formula that will multiply to cells when an x is placed in
another cell.

I would like a formula in cell H20, that when someone places an X or x
in cell C20, multiply cell D20 by cell F20, with the answer in H20.

Thanks for you time!

Jess

Guys, THANKS!

This formula did what I wanted to do, but the formula shows up in cell
H20 instead of being blank until after an x is place in C20



On Thu, 13 Apr 2006 14:13:18 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Jess

Entered in H20................

=IF(C20="x",D20*F20,"no x in C20")

You don't say what you want done if there is no x in C20, so I added the text.

Adjust to suit.


Gord Dibben MS Excel MVP


On Thu, 13 Apr 2006 15:56:30 -0500, Jess wrote:


Hello Folks,

I need a little help with what I think is a simply problem, but it is
over my head.

I need a formula that will multiply to cells when an x is placed in
another cell.

I would like a formula in cell H20, that when someone places an X or x
in cell C20, multiply cell D20 by cell F20, with the answer in H20.

Thanks for you time!

Jess

Oooops!

In my last post I state the formula is showing up in H20 instead of
being blank, which is a true statement, but there could be a 0 there
too instead of just being blank. The format for the cell is currency
$, so it would be $0.00 if not blank.

Again Thanks. I almost had the correct formula myself,
but............ just a little over my head.


On Fri, 14 Apr 2006 05:25:27 -0500, Jess
wrote:


Guys, THANKS!

This formula did what I wanted to do, but the formula shows up in cell
H20 instead of being blank until after an x is place in C20



On Thu, 13 Apr 2006 14:13:18 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Jess

Entered in H20................

=IF(C20="x",D20*F20,"no x in C20")

You don't say what you want done if there is no x in C20, so I added the text.

Adjust to suit.


Gord Dibben MS Excel MVP


On Thu, 13 Apr 2006 15:56:30 -0500, Jess wrote:


Hello Folks,

I need a little help with what I think is a simply problem, but it is
over my head.

I need a formula that will multiply to cells when an x is placed in
another cell.

I would like a formula in cell H20, that when someone places an X or x
in cell C20, multiply cell D20 by cell F20, with the answer in H20.

Thanks for you time!

Jess