I don't have to much experience in Excel but I need to find out how to run a
formula in a specific cell, for example if I enter 100.00 in A1 then come
back and want to enter 250.00 then press enter can I get it to answer 350.00?
Mike
I don't have to much experience in Excel but I need to find out how to run a
formula in a specific cell, for example if I enter 100.00 in A1 then come
back and want to enter 250.00 then press enter can I get it to answer 350.00?
Mike
To show 350 as the answer, type the following, followed by enter
=100+250
If you will be doing a lot of this, you might consider entering 100 in cell
A1, 250 in cell A2 and =SUM(A1:A3) in cell A4 (leaving cell A3 for an
additional value).
Stephen
http://groups.msn.com/HighlandsVillage where Villagers help each other
"Mike" wrote:
> I don't have to much experience in Excel but I need to find out how to run a
> formula in a specific cell, for example if I enter 100.00 in A1 then come
> back and want to enter 250.00 then press enter can I get it to answer 350.00?
>
> Mike
Mike, have a look here for a way to do it,
http://www.mcgimpsey.com/excel/accumulator.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Mike" <[email protected]> wrote in message
news:[email protected]...
> I don't have to much experience in Excel but I need to find out how to run
a
> formula in a specific cell, for example if I enter 100.00 in A1 then come
> back and want to enter 250.00 then press enter can I get it to answer
350.00?
>
> Mike
Thank you Paul. Unfortunaly I'm looking for somthing more simple, I guess I
didn't explain myself, what I need to find out is if XL can accumulate a
balance on a cell. I have a monthly report that I need to enter an amount on
a daily basis and from different persons and instead of adding it in a
calculator I wonder if XL could do the math for me, eg. in cell A1 I enter an
amount today then tomorrow I enter a different number on the same cell will
XL add it up to the number enter the previous date?
"Paul B" wrote:
> Mike, have a look here for a way to do it,
>
> http://www.mcgimpsey.com/excel/accumulator.html
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> > I don't have to much experience in Excel but I need to find out how to run
> a
> > formula in a specific cell, for example if I enter 100.00 in A1 then come
> > back and want to enter 250.00 then press enter can I get it to answer
> 350.00?
> >
> > Mike
>
>
>
Thank you Stephen, but I just want it all on the same cell if possible.
Otherwise I would use the AutoZum.
"StephenBiggins" wrote:
> To show 350 as the answer, type the following, followed by enter
> =100+250
>
> If you will be doing a lot of this, you might consider entering 100 in cell
> A1, 250 in cell A2 and =SUM(A1:A3) in cell A4 (leaving cell A3 for an
> additional value).
>
> Stephen
> http://groups.msn.com/HighlandsVillage where Villagers help each other
>
> "Mike" wrote:
>
> > I don't have to much experience in Excel but I need to find out how to run a
> > formula in a specific cell, for example if I enter 100.00 in A1 then come
> > back and want to enter 250.00 then press enter can I get it to answer 350.00?
> >
> > Mike
It won't get any more simple than that, if you want to enter a value in A1
and have it accumulate you need a worksheet event macro from the link Paul
posted (single cell accumulator)
--
Regards,
Peo Sjoblom
(No private emails please)
"Mike" <[email protected]> wrote in message
news:[email protected]...
> Thank you Paul. Unfortunaly I'm looking for somthing more simple, I guess
> I
> didn't explain myself, what I need to find out is if XL can accumulate a
> balance on a cell. I have a monthly report that I need to enter an amount
> on
> a daily basis and from different persons and instead of adding it in a
> calculator I wonder if XL could do the math for me, eg. in cell A1 I enter
> an
> amount today then tomorrow I enter a different number on the same cell
> will
> XL add it up to the number enter the previous date?
>
> "Paul B" wrote:
>
>> Mike, have a look here for a way to do it,
>>
>> http://www.mcgimpsey.com/excel/accumulator.html
>>
>> --
>> Paul B
>> Always backup your data before trying something new
>> Please post any response to the newsgroups so others can benefit from it
>> Feedback on answers is always appreciated!
>> Using Excel 2002 & 2003
>>
>> "Mike" <[email protected]> wrote in message
>> news:[email protected]...
>> > I don't have to much experience in Excel but I need to find out how to
>> > run
>> a
>> > formula in a specific cell, for example if I enter 100.00 in A1 then
>> > come
>> > back and want to enter 250.00 then press enter can I get it to answer
>> 350.00?
>> >
>> > Mike
>>
>>
>>
Mike, not with out useing some VBA like the link I gave you, but why not
just put you numbers in and let excel add them for you, put your numbers on
column A and put =SUM(A:A) in B1? this way you will have a record of the
numbers if you need to go back and check them
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Mike" <[email protected]> wrote in message
news:[email protected]...
> Thank you Paul. Unfortunaly I'm looking for somthing more simple, I guess
I
> didn't explain myself, what I need to find out is if XL can accumulate a
> balance on a cell. I have a monthly report that I need to enter an amount
on
> a daily basis and from different persons and instead of adding it in a
> calculator I wonder if XL could do the math for me, eg. in cell A1 I enter
an
> amount today then tomorrow I enter a different number on the same cell
will
> XL add it up to the number enter the previous date?
>
> "Paul B" wrote:
>
> > Mike, have a look here for a way to do it,
> >
> > http://www.mcgimpsey.com/excel/accumulator.html
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Mike" <[email protected]> wrote in message
> > news:[email protected]...
> > > I don't have to much experience in Excel but I need to find out how to
run
> > a
> > > formula in a specific cell, for example if I enter 100.00 in A1 then
come
> > > back and want to enter 250.00 then press enter can I get it to answer
> > 350.00?
> > >
> > > Mike
> >
> >
> >
Paul, I just did that and it worked great I actually used it like this
=SUM(10,20,50,), and like you said it keeps the numbers and it goes up to 30
entries.
Thanks,
Mike
"Paul B" wrote:
> Mike, not with out useing some VBA like the link I gave you, but why not
> just put you numbers in and let excel add them for you, put your numbers on
> column A and put =SUM(A:A) in B1? this way you will have a record of the
> numbers if you need to go back and check them
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> > Thank you Paul. Unfortunaly I'm looking for somthing more simple, I guess
> I
> > didn't explain myself, what I need to find out is if XL can accumulate a
> > balance on a cell. I have a monthly report that I need to enter an amount
> on
> > a daily basis and from different persons and instead of adding it in a
> > calculator I wonder if XL could do the math for me, eg. in cell A1 I enter
> an
> > amount today then tomorrow I enter a different number on the same cell
> will
> > XL add it up to the number enter the previous date?
> >
> > "Paul B" wrote:
> >
> > > Mike, have a look here for a way to do it,
> > >
> > > http://www.mcgimpsey.com/excel/accumulator.html
> > >
> > > --
> > > Paul B
> > > Always backup your data before trying something new
> > > Please post any response to the newsgroups so others can benefit from it
> > > Feedback on answers is always appreciated!
> > > Using Excel 2002 & 2003
> > >
> > > "Mike" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I don't have to much experience in Excel but I need to find out how to
> run
> > > a
> > > > formula in a specific cell, for example if I enter 100.00 in A1 then
> come
> > > > back and want to enter 250.00 then press enter can I get it to answer
> > > 350.00?
> > > >
> > > > Mike
> > >
> > >
> > >
>
>
>
Mike, if that works for you great, but looks like it would be easier to just
put the number in a column instead of having to edit the formula and put a ,
between each number
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Mike" <[email protected]> wrote in message
news:[email protected]...
> Paul, I just did that and it worked great I actually used it like this
> =SUM(10,20,50,), and like you said it keeps the numbers and it goes up to
30
> entries.
>
> Thanks,
> Mike
>
> "Paul B" wrote:
>
> > Mike, not with out useing some VBA like the link I gave you, but why not
> > just put you numbers in and let excel add them for you, put your numbers
on
> > column A and put =SUM(A:A) in B1? this way you will have a record of the
> > numbers if you need to go back and check them
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Mike" <[email protected]> wrote in message
> > news:[email protected]...
> > > Thank you Paul. Unfortunaly I'm looking for somthing more simple, I
guess
> > I
> > > didn't explain myself, what I need to find out is if XL can accumulate
a
> > > balance on a cell. I have a monthly report that I need to enter an
amount
> > on
> > > a daily basis and from different persons and instead of adding it in a
> > > calculator I wonder if XL could do the math for me, eg. in cell A1 I
enter
> > an
> > > amount today then tomorrow I enter a different number on the same cell
> > will
> > > XL add it up to the number enter the previous date?
> > >
> > > "Paul B" wrote:
> > >
> > > > Mike, have a look here for a way to do it,
> > > >
> > > > http://www.mcgimpsey.com/excel/accumulator.html
> > > >
> > > > --
> > > > Paul B
> > > > Always backup your data before trying something new
> > > > Please post any response to the newsgroups so others can benefit
from it
> > > > Feedback on answers is always appreciated!
> > > > Using Excel 2002 & 2003
> > > >
> > > > "Mike" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > I don't have to much experience in Excel but I need to find out
how to
> > run
> > > > a
> > > > > formula in a specific cell, for example if I enter 100.00 in A1
then
> > come
> > > > > back and want to enter 250.00 then press enter can I get it to
answer
> > > > 350.00?
> > > > >
> > > > > Mike
> > > >
> > > >
> > > >
> >
> >
> >
Mike
If you "must" have an accumulator cell, check this thread out before
proceeding.
http://snipurl.com/8e64
Gord Dibben Excel MVP
On Fri, 25 Nov 2005 19:40:55 -0500, "Paul B" <[email protected]>
wrote:
>Mike, if that works for you great, but looks like it would be easier to just
>put the number in a column instead of having to edit the formula and put a ,
>between each number
Gord,
Thank you I will keep it in mind.
Mike
"Gord Dibben" wrote:
> Mike
>
> If you "must" have an accumulator cell, check this thread out before
> proceeding.
>
> http://snipurl.com/8e64
>
>
> Gord Dibben Excel MVP
>
> On Fri, 25 Nov 2005 19:40:55 -0500, "Paul B" <[email protected]>
> wrote:
>
> >Mike, if that works for you great, but looks like it would be easier to just
> >put the number in a column instead of having to edit the formula and put a ,
> >between each number
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks