Formulas

S

Shariff A.

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

wjohnson

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)
 
S

Shariff A.

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