Formulas

Hello, I am trying to find a formula that will allow me to multiply the
value of one cell by simply typing a number into another cell. For example,
cell "B4" would have a dollar amount of $100; if I was to type in "1" in
"C4," it would automatically total to $100. Likewise, if I was to go to "D4"
and type in "2" it would total $200. I thought there was a formula for that,
but I cannot seem to find the right one. If anyone knows how to do this it
would be appreciated.

For your first example you will have to have your results show up in D4
As far as I know you cannot have a "formula" and a "manually" entered value in the same cell, (they will overwrite each other).
Your Example: cell "B4" would have a dollar amount of $100; if I was to type in "1" in "C4," it would automatically total to $100.
Your result will have to be in D4 or some other cell - the formula would be
=(B4*C4)

I appreciate that, thank you. I was under the impression the formula would
be =SUM(B4*NUM), but that did not work, and now I know why. Thanks again.

Shariff A.

"wjohnson" wrote:

>
> For your first example you will have to have your results show up in D4
> As far as I know you cannot have a "formula" and a "manually" entered
> value in the same cell, (they will overwrite each other).
> Your Example: cell "B4" would have a dollar amount of $100; if I was to
> type in "1" in "C4," it would automatically total to $100.
> Your result will have to be in D4 or some other cell - the formula
> would be
> =(B4*C4)
>
>
> --
> wjohnson
> ------------------------------------------------------------------------
> wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
> View this thread: http://www.excelforum.com/showthread...hreadid=500777
>
>