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

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