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

[Guest]

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 are:
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

 

[Scoops]

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 are:
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