I need a little help with a formula

[Jess]

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

 

[Paul B]

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

 

[Peo Sjoblom]

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

put that in H20


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Gord Dibben]

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

 

[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

 

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