Displaying results w/o Circular Reference

LaVerne

New Member
Joined
Oct 28, 2004
Messages
17
Does anyone have some code and or formula I can "borrow" to accomplish the following?

IF B2>=C2 Then D2=B2
ELSE IF B2<C2
THEN D2=C2

I want to write my formula in Cell D2 and display the results there also.

Any ideas?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Hi Laverne!

You could try ..

=IF(B2>=C2,B2,C2)


Does that help?
 

LaVerne

New Member
Joined
Oct 28, 2004
Messages
17
My amazing husband found the answer! Check this out!

=IF((A6>B6),A6,B6)

Which isn't complicated.
If you go to TOOLS, OPTIONS, CALCULATIONS:

Then change the Iterations to around 5. This stops the
circular reference and the formula displays the result in
the cell I wanted!

Now, does anyone know if changing this setting will
create any other problems in my workbook?
 

KenWright

Active Member
Joined
Jan 14, 2005
Messages
267
LaVerne, if that formula is going into cell D2 then there is nothing at all in there that would cause a circ, and certainly no need to change your calc settings. Firefytr has given you a working answer based on your original ranges, and likewise there is nothing at all in there either that would cause a circ.
 

LaVerne

New Member
Joined
Oct 28, 2004
Messages
17
Ken,
Actually the formula and the result are all in the same cell, hence the circ. reference. It was fine if I displayed it in an adjoining cell, just not in the same cell.

Thanks for the reply.
LaVerne
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
LaVerne, generally it's not needed to use circular references. It's very few and far between when they are actually needed. And even in those instances, I'd opt for another workaround. The generally accepted practice is to have a formula in a seperate cell, not referencing itself to perform calculations.

So does this mean you got it working then?
 

Forum statistics

Threads
1,147,621
Messages
5,742,184
Members
423,710
Latest member
Duarte85

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
Top