formula within same cell

M

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
 
S

StephenBiggins

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
 
M

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?
 
M

Mike

Thank you Stephen, but I just want it all on the same cell if possible.
Otherwise I would use the AutoZum.
 
P

Peo Sjoblom

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)
 
P

Paul B

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
 
M

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
 
P

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Grouping totals together by month per customer 6
Need formula to automatically populate Sheet 2 cells with same content as Sheet 1 1
Average 5
Word macro that can call cells out of Excel for a find and replace 0
Overwriting a cell with a formula without deleting the formula 1
Goal Seek with variable Set Cell 1
complicated excel formula may need an algebra wiz 1

Top