Calculation within Cells

		Microsoft Office Forums > Microsoft Excel > Excel
Calculation within Cells

FAQ

Thread Tools

Display Modes

12-07-2011, 10:00 AM

Pecoflyer

Windows XP Calculation within Cells

Office 2003

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Quote:

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.

Enter 7.87 in an empty cell
copy
select the target cell
Right click - Paste special
Check Add
OK
( I agree that is a long-winded way to do things)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:15 PM.