Hardcoding formulas

**Diandude** · 06-12-2012, 10:39 AM

Hello,

I have a formula that I want to apply to a cell. Now the problem is that the very same cell that I wan to apply the formula I also want to manually enter data, is there a way that I can do this.

For example I have a formula that reads the difference between A1 and B1 and puts it in B2, now I also want to manually write a number in B2 is there a way I can do this as to not delete my formula.

I believe this is known as a circular reference

Thanks In advance

**tkowal** · 06-12-2012, 10:46 AM

no

You will have to set up helper cells and create the rules to either use the formulated calculation or overwrite it.

example.xlsx

**brandonlaw** · 06-12-2012, 10:49 AM

What data do you want to enter in addition? Why can't you just use the next column?

**Diandude** · 06-12-2012, 11:00 AM

I have two cells one Name'd Forcast the other named actual.
Lets say that for example in A1, I have 20 hours forcasted and in B1 only 15 occured

And in A2 25 hours was forcasted and In B2 25 happened,
Now in B2 I want it to account for the remaining 5 hours of work so it should read 30 hours and I have to manually enter the 25.

Is there a way to do this without using another refrence cell keep in mind I am doing this for 200 plus units over a peroid of 2 years so it is a little harder to use 3 cells

**brandonlaw** · 06-12-2012, 11:05 AM

Originally Posted by Diandude

I have two cells one Name'd Forcast the other named actual.
Lets say that for example in A1, I have 20 hours forcasted and in B1 only 15 occured

And in A2 25 hours was forcasted and In B2 25 happened,
Now in B2 I want it to account for the remaining 5 hours of work so it should read 30 hours and I have to manually enter the 25.

Is there a way to do this without using another refrence cell keep in mind I am doing this for 200 plus units over a peroid of 2 years so it is a little harder to use 3 cells

That really doesn't make sense, just use a 3rd column and fill the formula down, it will take 10 seconds. Can you upload an example of what you want? I must not be understanding you.

**arlu1201** · 06-12-2012, 11:08 AM

Diandude,

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.