Prev: Remove duplicates from Sheet 2
Next: Conditional Formating based on start and end dates
From: Brian on 31 Mar 2010 08:06
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?
From: Mike H on 31 Mar 2010 08:09
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?
 | 
Pages: 1
Prev: Remove duplicates from Sheet 2
Next: Conditional Formating based on start and end dates