Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 683
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Manual calculation setting skewey Excel Discussion (Misc queries) 1 February 2nd 08 04:37 PM
Manual Calculation TeresaD Setting up and Configuration of Excel 7 January 28th 08 08:54 PM
Manual Input/Calculation in Same Cell Jean9 Excel Discussion (Misc queries) 3 November 8th 07 04:00 PM
Automatic/Manual Calculation PA New Users to Excel 4 September 8th 06 04:04 PM
Calculation set as Manual Dan. Excel Discussion (Misc queries) 1 February 14th 06 04:30 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"