Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill range don't change the formula, Help was no help. Please hel
I looked through Help and I looked in this forum - I am still not able to get
the fill formatting to do what I want. C D 2 40 3 350 140 4 400 5 670 6 40 7 200 8 350 cell 3B has the formula =C3*(D2/100) When I select 3B and drag down my formula changes the 3 and 2 in the formula to reflect the relationship it statred with. Can I get this to not happen? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill range don't change the formula, Help was no help. Please hel
Hi Russell,
Check the Help file on 'absolute references' for a complete explanation. Changing your formula to this will do what you require. =C$3*(D$2/100) HTH Martin "Trussell" wrote in message ... I looked through Help and I looked in this forum - I am still not able to get the fill formatting to do what I want. C D 2 40 3 350 140 4 400 5 670 6 40 7 200 8 350 cell 3B has the formula =C3*(D2/100) When I select 3B and drag down my formula changes the 3 and 2 in the formula to reflect the relationship it statred with. Can I get this to not happen? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill range don't change the formula, Help was no help. Please hel
I guess you do not want D2 to change but want C3 to change to C4, C5,.... If
that is the case then try =C3*(D$2/100) As Chip Pearson posted elsewhere today ______________ If you don't want part of a reference to change, put a $ character before that part of the reference. Excel won't change it when you copy it down. E.g., =$A$1 change neither row nor column =A1 change both row and column =$A1 change row but not column =A$1 change column but not row __________________________________________________ _____ You can select the reference and press F4 repeatedly to cycle through the choices. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Trussell" wrote: I looked through Help and I looked in this forum - I am still not able to get the fill formatting to do what I want. C D 2 40 3 350 140 4 400 5 670 6 40 7 200 8 350 cell 3B has the formula =C3*(D2/100) When I select 3B and drag down my formula changes the 3 and 2 in the formula to reflect the relationship it statred with. Can I get this to not happen? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill range don't change the formula, Help was no help. Please hel
Hi,
As an additional piece of info: =C3*(D2/100) can be written =C3*D2/100 no need for parens here. If my memory serves me division and multiplication are said to be distributive, which means their order is unimportant, so you don't need the parens. Primer on relative and absolute cell references By default almost all Excel formulas are relative - they adjust when you copy them. For example =SUM(A1:A10) in cell A11 is copied to B11 it becomes =SUM(B1:B11) its references are relative to the location of the formula. You can make any portion of a reference absolute by putting a $ in front of it. An absolute reference does not change when you copy it. Cell references come in 4 variations: A1 relative $A$1 absolute $A1 mixed - the A is absolute, the 1 is relative A$1 mixed - the A is relative, the 1 is absolute These ideas are a core component of Excel's formulas and everyone should master them! When you copy a formula down a column, in a formula reference like =SUM(A1:D1), the row numbers change but the column letter do not. To make the row numbers fixed, absolute, you can modify the formula to read =SUM(A$1:D$1). We might call this absolute but actually its mixed, but since we are copying up or down a column and not left or right, all portions of the references remain unchanging. Why should you know this? If you write a formula and copy it and then find you need to go back and modify it to get it to refer to the correct cells, it usually means you don't understand the concept of absolute/relative cell references. But more importantly you are working too hard, editing those formulas. If this is helpful, please click the Yes button. -- Thanks, Shane Devenshire "Trussell" wrote: I looked through Help and I looked in this forum - I am still not able to get the fill formatting to do what I want. C D 2 40 3 350 140 4 400 5 670 6 40 7 200 8 350 cell 3B has the formula =C3*(D2/100) When I select 3B and drag down my formula changes the 3 and 2 in the formula to reflect the relationship it statred with. Can I get this to not happen? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula that does not change the cell range | Excel Discussion (Misc queries) | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |