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

  • Thread starter im_not_excelling
  • Start date
I

im_not_excelling

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
 
S

Scoops

im_not_excelling said:
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
Click to expand...

Hi LJ

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

Regards

Steve
 
Top