Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Cell A1 is named "max"
Formula in A1 is: =IF(TOTAL_PORTFOLIO_VALUEmax,TOTAL_PORTFOLIO_VALU E,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 |