Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling automatic formula arguments
I have lived with this too long now. When I insert a formula into a cell the
calculation is taken literally as I typed it. But if I want to apply this same formula to alot of cells I either cut and past or drag the cell contents to the cells that I wish to apply the formula to. Excel tries to modify the arguments assuming that the arguments that I used in the formula are relative. But I frequently run into the situation where part of the formula is a constant and I don't want Excel to modify the row or column that is used just take the row and column as a constant. For example right now I define a cell function as =POISSON(A1,A32,TRUE). If I copy this formula to another cell the first argument (the x value) is modified to say A2. This is OK. But the problem is that the second argument (A32) is changed to A33 and that should be constant. So instead of =POISSON(A2,A32,TRUE) I get ==POISSON(A2,A33,TRUE) etc. How can I disable this automatic argument adjustment? Thank you. Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling automatic formula arguments
You could use an absolute address:
=POISSON(A1,$A$32,TRUE) The $ "fixes" that portion of the address so it won't adjust when the formula is copied to other cells. Kevin Burton wrote: I have lived with this too long now. When I insert a formula into a cell the calculation is taken literally as I typed it. But if I want to apply this same formula to alot of cells I either cut and past or drag the cell contents to the cells that I wish to apply the formula to. Excel tries to modify the arguments assuming that the arguments that I used in the formula are relative. But I frequently run into the situation where part of the formula is a constant and I don't want Excel to modify the row or column that is used just take the row and column as a constant. For example right now I define a cell function as =POISSON(A1,A32,TRUE). If I copy this formula to another cell the first argument (the x value) is modified to say A2. This is OK. But the problem is that the second argument (A32) is changed to A33 and that should be constant. So instead of =POISSON(A2,A32,TRUE) I get ==POISSON(A2,A33,TRUE) etc. How can I disable this automatic argument adjustment? Thank you. Kevin -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disabling automatic formula arguments
An easy way to insert those $ signs is the F4 key. When entering or editing a formula, if the cursor is on a cell reference,
pressing F4 toggles variations of the relative/absolute references. -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave Peterson" wrote in message ... | You could use an absolute address: | | =POISSON(A1,$A$32,TRUE) | | The $ "fixes" that portion of the address so it won't adjust when the formula is | copied to other cells. | | Kevin Burton wrote: | | I have lived with this too long now. When I insert a formula into a cell the | calculation is taken literally as I typed it. But if I want to apply this | same formula to alot of cells I either cut and past or drag the cell contents | to the cells that I wish to apply the formula to. Excel tries to modify the | arguments assuming that the arguments that I used in the formula are | relative. But I frequently run into the situation where part of the formula | is a constant and I don't want Excel to modify the row or column that is used | just take the row and column as a constant. For example right now I define a | cell function as =POISSON(A1,A32,TRUE). If I copy this formula to another | cell the first argument (the x value) is modified to say A2. This is OK. But | the problem is that the second argument (A32) is changed to A33 and that | should be constant. So instead of =POISSON(A2,A32,TRUE) I get | ==POISSON(A2,A33,TRUE) etc. How can I disable this automatic argument | adjustment? | | Thank you. | | Kevin | | -- | | Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling formula | Excel Discussion (Misc queries) | |||
Disabling Automatic Date Thing | Excel Discussion (Misc queries) | |||
Disabling Automatic Date Thing | Excel Discussion (Misc queries) | |||
arguments in a formula | Excel Discussion (Misc queries) | |||
How do I add more than 30 arguments in a formula | Excel Worksheet Functions |