Seeking the collective wisdom of this community

dhaynes

New Member
Joined
Mar 13, 2020
Messages
18
Office Version
  1. 365
Platform
  1. Windows
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~
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
At this point, I don't see a way around it using a formula unless I knew more about those cells
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top