software

I have a spreadsheet linked to life stock market prices.

Cell I17 is named quot;maxquot; and it contains the following formula that displays
the maximum portfolio value:

=IF(TOTAL_PORTFOLIO_VALUEgt;max,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

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.

Cheersquot;Antonioquot; gt; wrote in message
...
gt; I have a spreadsheet linked to life stock market prices.
gt;
gt; Cell I17 is named quot;maxquot; and it contains the following formula that
displays
gt; the maximum portfolio value:
gt;
gt; =IF(TOTAL_PORTFOLIO_VALUEgt;max,TOTAL_PORTFOLIO_VALU E,max)
gt;
gt; The problem is that it has a circular reference and I have to turn on
gt; iterations.
gt;
gt; Is there a better way to do it?
gt;
gt; Thanks,
gt;
gt; Antonio
Hi, thank you for your reply.

Your formula does not give the session maximum.

It calculates the max of two numbers, but it does not keep the previous max.
Thus it does not give the session.

quot;macropodquot; wrote:

gt; Hi Antonio,
gt;
gt; Your formula is essentially the same as:
gt; =MAX(TOTAL_PORTFOLIO_VALUE,max)
gt; but this won't affect your circular referencing problem.
gt;
gt; By the sounds of it, you're using this formula in a cell falling within the
gt; named range 'TOTAL_PORTFOLIO_VALUE' and/or 'max'. Hence the circular
gt; reference. The simplistic fix would be to put the formula in a cell that
gt; isn't included in either of those ranges.
gt;
gt; Cheers
gt;
gt;
gt; quot;Antonioquot; gt; wrote in message
gt; ...
gt; gt; I have a spreadsheet linked to life stock market prices.
gt; gt;
gt; gt; Cell I17 is named quot;maxquot; and it contains the following formula that
gt; displays
gt; gt; the maximum portfolio value:
gt; gt;
gt; gt; =IF(TOTAL_PORTFOLIO_VALUEgt;max,TOTAL_PORTFOLIO_VALU E,max)
gt; gt;
gt; gt; The problem is that it has a circular reference and I have to turn on
gt; gt; iterations.
gt; gt;
gt; gt; Is there a better way to do it?
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Antonio
gt;
gt;
gt;

Hi Antonio,

That's what you get for having the formula in the cell named 'max' (I17).
Putting a formula in a cell that the formula refers to creates a circular
reference - there's no way around that.

Cheers

quot;Antonioquot; gt; wrote in message
news
gt; Hi, thank you for your reply.
gt;
gt; Your formula does not give the session maximum.
gt;
gt; It calculates the max of two numbers, but it does not keep the previous
max.
gt; Thus it does not give the session.
gt;
gt; quot;macropodquot; wrote:
gt;
gt; gt; Hi Antonio,
gt; gt;
gt; gt; Your formula is essentially the same as:
gt; gt; =MAX(TOTAL_PORTFOLIO_VALUE,max)
gt; gt; but this won't affect your circular referencing problem.
gt; gt;
gt; gt; By the sounds of it, you're using this formula in a cell falling within
the
gt; gt; named range 'TOTAL_PORTFOLIO_VALUE' and/or 'max'. Hence the circular
gt; gt; reference. The simplistic fix would be to put the formula in a cell that
gt; gt; isn't included in either of those ranges.
gt; gt;
gt; gt; Cheers
gt; gt;
gt; gt;
gt; gt; quot;Antonioquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I have a spreadsheet linked to life stock market prices.
gt; gt; gt;
gt; gt; gt; Cell I17 is named quot;maxquot; and it contains the following formula that
gt; gt; displays
gt; gt; gt; the maximum portfolio value:
gt; gt; gt;
gt; gt; gt; =IF(TOTAL_PORTFOLIO_VALUEgt;max,TOTAL_PORTFOLIO_VALU E,max)
gt; gt; gt;
gt; gt; gt; The problem is that it has a circular reference and I have to turn on
gt; gt; gt; iterations.
gt; gt; gt;
gt; gt; gt; Is there a better way to do it?
gt; gt; gt;
gt; gt; gt; Thanks,
gt; gt; gt;
gt; gt; gt; Antonio
gt; gt;
gt; gt;
gt; gt;