|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
02-16-2005, 02:53 PM
|
#1 |
|
Member (8 bit)
Join Date: Jan 2004
Posts: 162
|
Excel Formula
I have a column of numbers that I would like to divide each number by 2. I thought I knew excel quite well....I don't. What mod do I type that would divide these numbers by two. The numbers range from D7 to D110. I searched every where, but am probably asking it incorrectly. Thanks -matt
|
|
|
|
02-16-2005, 02:57 PM
|
#2 |
|
Barefoot on the Moon!
Staff
Premium Member
Join Date: Aug 2002
Location: Northeastern USA
Posts: 13,384
|
What is the destination cell for the final value?
Are you adding all the numbers, then dividing by 2, or is each individual number being divided by 2, and each answer is being put into a cell?
__________________
There are two secrets to staying young, being happy, and achieving success. You have to laugh and find humor every day, and you have to have a dream.
|
|
|
|
|
02-16-2005, 03:05 PM
|
#3 |
|
Member (8 bit)
Join Date: Jan 2004
Posts: 162
|
each number being divided by 2 and that value replacing the privious value in that cell
thank you |
|
|
|
|
02-16-2005, 03:19 PM
|
#4 |
|
Barefoot on the Moon!
Staff
Premium Member
Join Date: Aug 2002
Location: Northeastern USA
Posts: 13,384
|
I'm not sure if that's possible or not. You will run into a circular reference problem.
What I suggest is to have a seperate block of cells to imput your numbers, (for example, G7-G110) then for cells D7-D110, put in the equation. Example: for D7, the equation would be: =G7/2 |
|
|
|
|
02-16-2005, 03:33 PM
|
#5 |
|
Member (8 bit)
Join Date: Jan 2004
Posts: 162
|
Thank you Force. It was the circular reference problem that I kept on encountering. I did one equation in column g then just copied and pasted all the way down and it divided and I just moved it to the correct spot. Just when you think you got it figured out a simple math equation in excel sets you straight. thanks again -matt
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
