Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set a constant from a formula in VBA Ed Excel Discussion (Misc queries) 1 December 1st 06 02:31 AM
Need help with writing formula please... Soth Excel Worksheet Functions 1 March 14th 06 08:03 PM
Formula Constant dale1948 Excel Worksheet Functions 2 November 2nd 05 10:44 PM
Constant Value in formula. Nomad Excel Worksheet Functions 1 March 28th 05 08:53 PM
I need help writing a formula. John III Excel Worksheet Functions 4 December 31st 04 08:26 PM


All times are GMT +1. The time now is 05:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"