Thread: max
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonio Antonio is offline
external usenet poster
 
Posts: 134
Default max

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