Split from http://www.ozgrid.com/forum/showthread.php?t=102469

Quote from AAEDisplay MoreWelcome to Ozgrid. :smile:

Assume the following:

Cell A1: is the input cell

Cell B1: contains a number

Cell C1: formula = A1*B1 or $A$1*$B$1

Your formulas must contains absolute cell references, other wise Excel will attempt to update them to the new cell references when copying/pasting.

If you "cut", rather than copy, Excel will maintain the original cell references in the formula.

Both of these questions are well within the experience level of a user with above average skill level as your profile shows. Please lower it (before one of the Admins does it for you) to a more realistic level.

See this training page on how to toggle between relative/absolute cell references: http://www.ozgrid.com/Excel/fr…excel-lesson-17-basic.htm

Well cutting is a nifty trick, thank you for that, I don't believe you quite understood my first question.

Lets use my calculator for instance. Using something it has designated K (for no apparent reason) I can enter a formula, such as K=*2-4, and after that is entered every number I then type and press equals to it will run that formula and spit out an answer. (after entering that function, if I press "5" "equals" it will give me "6") Now what I'm wondering is if excel has a "K" function that I can assign to certain cells, namely a column, so that whenever a figure is typed in any of the cells in that column, the required operation is done, namely *.9685.

Thanks in advance.

PS: And I do consider myself above average for the sole reason that I know far more then every other person I have ever met in real life. And from that fact I can, in my opinion, safely assume that I know more then *most* people, hence I am above average. Not to say that I know everything or even a great bulk of everything or even 1/10 of everything, just more then the average person.