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