#1
|
|||
|
|||
Calculation within Cells
Hi,
This may sound simple but how do you format a Cell so that when you add an additional figure it is added to the one already there,for example a row containing a cell for miscellaneous items which can not be summed with anything else. ie cell contains the figure £23.89 and i want to ad £7.87 to this,is there a way to just highlight the existing figure/cell,type the additional amount and let excel do the calculation.At the moment i am doing the calculation manually and adding the result to the cell. Hope this makes sense Mark |
#2
|
||||
|
||||
Quote:
copy select the target cell Right click - Paste special Check Add OK ( I agree that is a long-winded way to do things) |
#3
|
||||
|
||||
Alternatively, so that you can continue to see the component parts of the cell value in the formula bar, simply insert a '=' sign before the first # (you might even make this a habit for the initial data entry), then insert a '+' sign followed by the second value. You can keep inserting '+' (or '-') signs followed by values as required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Calculation Problem | UnholySmoke | Excel | 2 | 09-14-2011 08:15 AM |
Help with 'hours worked' calculation... | Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Mail Merge Calculation Error | Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |