I have a spreadsheet linked to life stock market prices.

Cell I17 is named "max" and it contains the following formula that displays
the maximum portfolio value:

=IF(TOTAL_PORTFOLIO_VALUEmax,TOTAL_PORTFOLIO_VALU E,max)

The problem is that it has a circular reference and I have to turn on
iterations.

Is there a better way to do it?

Thanks,

Antonio