Excel Question ?????

Question

FOR EXAMPLE:
WHEN I TYPE “10” IN CELL “A1” I WANT EXCEL TO MULTIPLY 10 X .50 IN THE SAME CELL AND CHANGE THE 10 TO 5
CAN ANY ONE HELP?
THANK YOU

Answer 1

You wont be able to do that on the fly. It would require a macro.
Here's the problem: Suppose you *could* somehow get a formula in cell A1 that takes the value in A1 and halves it. What is stopping it from taking the new value 5 and halving that? And then again... and again... It would recursively half itself until the value in A1 would effectively be zero.
The other obvious problem is you cant have a formula in a field and then type a value into it. The value you type will overwrite the formula.
If you however write a macro to multiply A1*.5 and then invoke it when you want to, that will work. But then you could invoke it again, and again and then we are back to the same problem.

What you should probably to do is have a data entry area of your spreadsheet (perhaps a separate sheet in the same workbook) and then a calculated area. In the data entry area you would type your values, and then the calculated area would have the formulas. If you use the separate sheet method you could even correspond the cell references straight across. Type into sheet1!A1, and in sheet2!A1 you have the formula: =Sheet1!A1*0.5