ExcelBanter - Formula for multiple cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula for multiple cells (https://www.excelbanter.com/excel-worksheet-functions/196413-formula-multiple-cells.html)

spezticle

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.

All times are GMT +1. The time now is 03:28 PM.