Calculating cell to equal a certain number (circular reference help)

  • Thread starter Thread starter SupraLB
  • Start date Start date
S

SupraLB

There must be a simple way to solve this problem, but I'm just learning
here.

Here is a picture of my problem.

[image: http://www.excelforum.com/attachment.php?s=&postid=317603 ]

I'm trying to make the Yellow C8=4, so that the column will add up to
10. I want C8 to be a formula, but I have "circular reference"
problems.

How do I make C8 add up the numbers to equal my desired number of "10"?
I want C8 to be able to increase/decrease at all times so that the
total will always equal "10" - even if the C4, C5, C6, and C7 cells
change.

THANKS for any help!!

File Attached: http://www.excelforum.com/attachment.php?postid=317603 (excel.jpg)
 
I may be making this more trivial than it is, but couldn't you just use
In C8:
= 10 - C9
OR
= 10 - SUM(C4:C7)

Dan E
 
B8 = YOUR TARGET TOTAL

C8 =IF(SUM(C4:C7)=B8,0,IF(SUM(C4:C7)<B8,B8-SUM(C4:C7),IF
(SUM(C4:C7)>B8,B8-SUM(C4:C7),"WRONG")))


SURE THERE IS PROBABLY AN EASIER WAY....
BUT ONE OF THE GENUISES WILL HAVE TO FIGURE THAT OUT.

HAVE FUN
 
Back
Top