mathematical function

[oscar5]

How do I create a function or formula that a cell should automatically multiple every number i enter, for example i want every number that i enter into cell A1 should get multiplied by 12 if i enter number 5 in A1 then number 60 should appear in cell A1

[pynergee]

I do not believe you would be able to do such a thing, at least using a simple formula. It would give errors with a circular reference, for example, you are saying A1=A1*12. However, you can easily do B1 = A1*12, and B1 with result in 60 if you input 5 into A1. You can copy this down for as many cells below as you need, and if you need the results in Column A instead of B, you can just Ctrl+C, and "Paste Values" into Column A.

[Ace_XL]

check this out..

http://www.mrexcel.com/forum/excel-q...ply-value.html

[oscar5]

thanks but i want the same cell i enter the data should get multiplied

[BB1972]

oscar5, welcome to the forum.

thanks but i want the same cell i enter the data should get multiplied

Did you read the article that Ace provided the link to? That's what the OP over there wanted, also. I followed the instructions provided, and was able to achieve what you want to do.

[oscar5]

i cant read that code

[BB1972]

Oscar, you don't need to be able to read much of the code to make use of it. On the attached workbook, I - disregarding what the code actually says - just copied the code and pasted it into a code module as outlined in the thread.

If you right-click where it says "Sheet1" (the tabname for Sheet1) then click on "View Code", you should see the code (at least I hope you will - I haven't used Excel 2003 for a considerable amount of time now.) I think the line that concerns you most at the moment is the 3rd line down: "Const SET_VALUE As Long = 12 ". This is the set value that you want to multiply whatever number you type into cell A1 by. If you want to multiply, for example, by 10 instead of 12, simply replace this value (12) with 10.

If you type 5 into cell A1, then press return/enter, you should see the value of A1 change to 60.

Hope this helps.