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

matthew544 · #1 09-17-2011, 08:26 AM

Does anyone know if I can use a formula to automatically change the value in one cell so that two other cells will have equal values? For example, I want B1 and C1 to be equal numbers. The number in B1 is calculated using a formula and is affected by the value in A1. C1 is calculated with a formula based on various other cells. So, once C1 is calculated, I want the value in A1 to change so that the value in B1 equals the value in C1. Right now, I am just changing A1 manually through trial and error. I would like to automate it somehow.

Thanks for any help that anyone can provide. Let me know if this is confusing.

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