Displaying results w/o Circular Reference

[LaVerne]

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?

 

[Zack Barresse]

Hi Laverne!

You could try ..

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


Does that help?

 

[LaVerne]

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]

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]

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]

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?