ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I add to a cell value without manual calculation? (https://www.excelbanter.com/excel-discussion-misc-queries/260326-can-i-add-cell-value-without-manual-calculation.html)

Brian

Can I add to a cell value without manual calculation?
 
I have a value in a cell eg 100 and want to add another value to it eg 10.
Can this be done by entering the additional value and the sum completed
automatically?

Mike H

Can I add to a cell value without manual calculation?
 
Brian,

You can do it like this. Put 10 in a cell and copy it.

Select the cell with 100 in it and right click - paste special - select
'ADD' - OK

Delete the 10 from the cell
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Brian" wrote:

I have a value in a cell eg 100 and want to add another value to it eg 10.
Can this be done by entering the additional value and the sum completed
automatically?



All times are GMT +1. The time now is 02:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com