Hi Antonio,

Your formula is essentially the same as:
=MAX(TOTAL_PORTFOLIO_VALUE,max)
but this won't affect your circular referencing problem.

By the sounds of it, you're using this formula in a cell falling within the
named range 'TOTAL_PORTFOLIO_VALUE' and/or 'max'. Hence the circular
reference. The simplistic fix would be to put the formula in a cell that
isn't included in either of those ranges.

Cheers


"Antonio" wrote in message
...
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