Formula for multiple cells

  • Thread starter Thread starter spezticle
  • Start date Start date
S

spezticle

I need to be able to input a number in cells a1 through a10.

I need those numbers to reflect a formula, IN the cell i typed the number in.

Example:

cell a4, i type in 4.
the formula multiplies 4 * .01 (turning 4 into a percent number) THEN by 2000.

So, when i input the number 4, i get displayed 80.

Any insight is much appreciated.
 
spezticle,
Try this :
In cell A4 4
In cell that you want the 80 to appear
type "=((A4*0.01)*2000)" without the "".
hth
Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logical formatting for multiple values 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Addition errors with Decimal Places 5
count - but exclude counting cells with a formula 4
Rank Formula 1
Formula to answer YES or No 4
Counting formula 1
min if horizontal 0

Back
Top