Help with a simple formula please

Lets says your first weight is in cell B5. In B5 enter
=210

Now you want to add 60 kg more. Simple add to the above entry
+60

So it looks like
=210+60

The result will be 270


Mangesh

Originally Posted by jonifresh

Hi, I'ts very rare i get round to working with excel so please accept my lack of knowledge in this area.

We use excel at work for a basic database, jobs customer name, weights etc.
The weights colum is the one that seems to be changed most frequently, we input a weight into say (cell 5B) 2110kg and then later on in the day an additional weight may come in - meaning the figure in 5B will need to be updated with the extra weight's. Instead of having to use the calculator to get these figures, i was wondering if it's possible to have a simple formula to add this figure up automatically. Like cell 5B + new data = total
the results will need to stay in the same cell if you know what i mean.

Thanks for any help


Wayne

one way is that you should enter the updated weight in cell B5 by overwriting the previous one. (just click on the cell B5 and enter new weight).

but if you want to see that how many times a weight is updated in a cell then put weight as
=2110&" "&"Kg"
and when you need to update it say to add more 20 to it, put it as follows after double clicking the cell
=2110+20&" "&"Kg"
add more 50 in it as
=2110+20+50&" "&"Kg"
less 30 from it
=2110+20+50-30&" "&"Kg"

other way is to manage it in a table formate like following one

Please Login or Register  to view this content.

hope this would help you.

Regards.

WoW - cheers for the info. Wasn't expecting a reply so soon.
will have a go in a while and let you know how it goes.

Thanks W.J

Originally Posted by jonifresh

WoW - cheers for the info. Wasn't expecting a reply so soon.
will have a go in a while and let you know how it goes.

Thanks W.J

thank you for the feedback
let me know if you could get your work done through this.