Seeking the collective wisdom of this community

[dhaynes]

I have run myself in circles on this but I am sure there is a simple solution that I am missing...at the end of the day I have two cells with formulas that result in a circular reference error. I am thinking I probably need a VBA solution but not sure. I will do my best to desribe the issue in the most straightforward manner:

Forumla in cell B63:
=IF(B7<=6000000,50000,$C$63*$B$7)

Formula in cell C63
=IF(AND(OR(SUM($C$36:$C$38)>=50%,SUM($B$36:$B$38)>=50%),B7>=6000001,B7<=12000000),$C$62-$E$62,$B$63/$B$7)

This forumla works well as long as the value in cell B7 is not greater than $12,000,001 b/c at that point, a circular reference error is generated.

Any ideas? Happy to answer any clarifying questions. Thank you for your time~

 

[Jeffrey Mahoney]

At this point, I don't see a way around it using a formula unless I knew more about those cells

 

[StephenCrump]

Effectively, you have:

B63: = C63*B7
C63: = B63/B7

VBA isn't going to help. If this is the correct relationship between B63 and C63, then you'll need to specify a value, either for B63 or for C63.