Issues with my excel formula as it needs Circular reference - hlp
 

Hi all,

I am trying to create a function that will display and update the highest
total achieved in sales and purchase ledger type spreadsheet

Other deisred values a
Current total (this is fine I use sum etc to achieve)
Lowest Total: (like highest total, this would check and update its own value)
Previous Highest total: a mostly static total

an example can be found at
http://web.aanet.com.au/tafehouse/excel-help/

LJ

Issues with my excel formula as it needs Circular reference - hlp
 

im_not_excelling wrote:
Hi all,

I am trying to create a function that will display and update the highest
total achieved in sales and purchase ledger type spreadsheet

Other deisred values a
Current total (this is fine I use sum etc to achieve)
Lowest Total: (like highest total, this would check and update its own value)
Previous Highest total: a mostly static total

LJ

Hi LJ

Take a look at =MAX() and =MIN()

Regards

Steve