Automatically change the value of one cell so that two other cells become equal

		Microsoft Office Forums > Microsoft Excel > Excel
Automatically change the value of one cell so that two other cells become equal

FAQ

Thread Tools

Display Modes

09-18-2011, 07:13 AM

matthew544 matthew544 is offline

Windows XP Automatically change the value of one cell so that two other cells become equal

Office 2010 32bit

Novice

Join Date: Jul 2011

Posts: 6

I attached an example. In the example, C1 equals the sum of D1, E1 and F1. B1 equals A1 + E1. In this particular instance, the value of C1 is 6. I want the value of A1 to automatically become 4, so that B1 will also equal 6 and thus equal C1.

Is that possible? Thanks.

Attached Files

test.xlsx (8.6 KB, 18 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to make cells shift down automatically	iffy	Excel	7	04-15-2013 08:06 AM
How to combine different cells data in one cell?	Learner7	Excel	1	07-28-2010 12:07 PM
How can I change the colors of cells automatically based on Job Completion?	Learner7	Excel	0	07-06-2010 10:47 PM
Dividing merge cell into ten equal rectangles for inputing Digit?	aligahk06	Excel	0	05-12-2010 06:56 AM
format cells to automatically place quotes around text	dirtleg	Excel	1	09-16-2008 01:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 AM.