I want to set up a cell where 1=3 so when I insert 2 it will =
You are very close to what I am tring to do. Let me see if this makes sense.
I would like to have A1 as the constant lets say A1 is 5 and when I enter a
number in B1 lets say 5, I would like for it to say 25 and when I put a
number in c1 lets say 2 i would like to have the number 10 and at the same
time not have to put the =A1*# in each cell. Just base it off the A1 cell.
Hopefully that makes sense. Also I will only be using A1 for only the 1
range, B,C,D... and no total at the end, and the A2 for only the 2 range
ect....
"Gord Dibben" wrote:
In B1 enter = A1*3
Whatever you enter in A1 will be multiplied by 3
Gord Dibben MS Excel MVP
On Sat, 9 Sep 2006 12:09:01 -0700, Ciscokid
wrote:
I am setting up a Excel worksheet for accountibility and what to simplify it
by having one number in a column equal another number in the next cell. I am
using Excel 2003
|