Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing a formula with a constant
It has been a long time since I did this and I cannot remember how...I have a
column of numbers that I want to divide by .80......I cannot replicate or duplicate because it just copies the first cell. I think I remember from long ago you 'bracket' or something to copy that one constanent to the next field. -- Barb |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing a formula with a constant
It sounds like you want to reference the cell that contains the .80 as an
absolute reference. To prevent the divisor from changing when copied do the following: Assuming that your values are in column A starting in row 1, the divisor is in E1, and you want the results in column B, enter the following formula: =A1/$E$1 Then copy the formula down column B. Another option would be to enter your divisor in a blank cell, and then copy that cell to the clipboard. After copying the divisor, select the cell containing the values that you want to divide and click EDIT in the menu, select PASTE SPECIAL, click the DIVIDE option button and click OK. The original values selected are now replaced by the result of the division. Hope this helps. -- Kevin Backmann "Barb" wrote: It has been a long time since I did this and I cannot remember how...I have a column of numbers that I want to divide by .80......I cannot replicate or duplicate because it just copies the first cell. I think I remember from long ago you 'bracket' or something to copy that one constanent to the next field. -- Barb |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Writing a formula with a constant
Thank you so very much. I was actually able to use the 'paste special'
function to resolve this particular task. -- Barb "Kevin B" wrote: It sounds like you want to reference the cell that contains the .80 as an absolute reference. To prevent the divisor from changing when copied do the following: Assuming that your values are in column A starting in row 1, the divisor is in E1, and you want the results in column B, enter the following formula: =A1/$E$1 Then copy the formula down column B. Another option would be to enter your divisor in a blank cell, and then copy that cell to the clipboard. After copying the divisor, select the cell containing the values that you want to divide and click EDIT in the menu, select PASTE SPECIAL, click the DIVIDE option button and click OK. The original values selected are now replaced by the result of the division. Hope this helps. -- Kevin Backmann "Barb" wrote: It has been a long time since I did this and I cannot remember how...I have a column of numbers that I want to divide by .80......I cannot replicate or duplicate because it just copies the first cell. I think I remember from long ago you 'bracket' or something to copy that one constanent to the next field. -- Barb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set a constant from a formula in VBA | Excel Discussion (Misc queries) | |||
Need help with writing formula please... | Excel Worksheet Functions | |||
Formula Constant | Excel Worksheet Functions | |||
Constant Value in formula. | Excel Worksheet Functions | |||
I need help writing a formula. | Excel Worksheet Functions |