max

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Cell A1 is named "max"

Formula in A1 is:
=IF(TOTAL_PORTFOLIO_VALUE>max,TOTAL_PORTFOLIO_VALUE,max)

this calculates the maximum Total Portfolio Value that is updated every
second with life market prices

The problem is that it has an implicit circular reference that I solve by
iteration.

Anybody knows of a different way to calculate the max without a circular
reference?

Thanks,

Antonio
 
Antonio said:
Cell A1 is named "max"

Formula in A1 is:
=IF(TOTAL_PORTFOLIO_VALUE>max,TOTAL_PORTFOLIO_VALUE,max)

this calculates the maximum Total Portfolio Value that is updated
every second with life market prices

The problem is that it has an implicit circular reference that I
solve by iteration.

Anybody knows of a different way to calculate the max without a
circular reference?

Thanks,

Antonio
Click to expand...

Why is it a "problem"?
 
The problem is twofold:

1. "Calculate" is permanently in the task bar. The spreadsheet is large and
complex with plenty of macros that turn calculation on and off and I do not
know for sure when I need to recalculate.

2. The iterations needed do slow down the calculation of the spreadsheet
(although I only do 2 iterations).

These are not major problems but the situation is not optimal.

Thanks,

Antonio
 
Back
Top