How can I use circular references that are allowed in Lotus 123?
 

I try to write a formula that has a variable value in column F which is
compared to column H. Column H should always contain highest value of the
two columns: If(F3H3, F3,H3). This works in Lotus 123 but not Excel 2003.
Help!

How can I use circular references that are allowed in Lotus 123?
 

Put your formula in another column. Or, if you *insist* on using circular
reference, under Tools-Options - calculation, set calculation to manual with
an iteration of 1. You could now use a circular reference, and press F9 to
cycle through 1 calculation.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DAVIDDON" wrote:

I try to write a formula that has a variable value in column F which is
compared to column H. Column H should always contain highest value of the
two columns: If(F3H3, F3,H3). This works in Lotus 123 but not Excel 2003.
Help!