Formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shariff A. - 12 Jan 2006 19:06 GMT

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.

Reply to this Message

wjohnson - 12 Jan 2006 19:55 GMT

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)

Signature

wjohnson

Reply to this Message

Shariff A. - 12 Jan 2006 20:15 GMT

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.

> 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
[quoted text clipped - 4 lines]
> would be
> =(B4*C4)

Reply to this Message