Formula for multiple cells
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.
|