Results 1 to 9 of 9

Thread: Libreoffice Calc: track minimum of two cells

  1. #1
    Join Date
    Apr 2014
    Location
    "Great North Wet"
    Posts
    133

    Default Libreoffice Calc: track minimum of two cells

    I have a cell whose value changes every 5 minutes A1.
    In A2 I can track the High value with =MAX(A1,A2)
    In A3 I want to track the low value so I tried =MIN(A1,A3) but it always goes to zero
    Any ideas on how can i get this to work?
    My goal is to be able to see 3 values Current,High, and Low at any time during the day (stock spreadsheet)
    Turkey Creek Jack Johnson: Nobody move!
    Doc Holliday: Nonsense. By all means, move.

  2. #2
    Join Date
    Jun 2008
    Location
    Yorkshire
    Posts
    335

    Default Re: Libreoffice Calc: track minimum of two cells

    I think you would need to start with a number in A3 or it will always be zero. MIN(A1,A3) picks the lower number so if A3 starts with zero or null, it will never change unless A1 has a negative number.
    Pete

  3. #3
    Join Date
    Apr 2014
    Location
    "Great North Wet"
    Posts
    133

    Default Re: Libreoffice Calc: track minimum of two cells

    Quote Originally Posted by peteh100 View Post
    I think you would need to start with a number in A3 or it will always be zero. MIN(A1,A3) picks the lower number so if A3 starts with zero or null, it will never change unless A1 has a negative number.
    Thanks for responding. Yeh, I've tried that, it just changes to zero when i hit enter when entering the MIN formula
    Turkey Creek Jack Johnson: Nobody move!
    Doc Holliday: Nonsense. By all means, move.

  4. #4
    Join Date
    Jun 2008
    Location
    Yorkshire
    Posts
    335

    Default Re: Libreoffice Calc: track minimum of two cells

    I can't get your =Max(a1,a2) to work, I get err522, but if somehow it's working for you, wouldn't a3's formula be =max(a1,a2) also?
    Pete

  5. #5
    Join Date
    Apr 2014
    Location
    "Great North Wet"
    Posts
    133

    Default Re: Libreoffice Calc: track minimum of two cells

    Here is a sample spreadsheet illustrating the problem
    http://nisquallyhighlands.net/Sample.ods
    Turkey Creek Jack Johnson: Nobody move!
    Doc Holliday: Nonsense. By all means, move.

  6. #6
    Join Date
    Jun 2008
    Location
    Yorkshire
    Posts
    335

    Default Re: Libreoffice Calc: track minimum of two cells

    My last response had a typo - 'max' instead of 'min' but that doesn't work as you've no doubt found out. You need an 'if() formula around the 'min()' to get it started but I haven't worked out exactly how. If you can, I'd be interested to see how.
    Pete

  7. #7
    Join Date
    Jun 2008
    Location
    Yorkshire
    Posts
    335

    Default Re: Libreoffice Calc: track minimum of two cells

    I don't know if you've got it yet but this works
    =if(a3=0,a1,min(a1,a3))
    in a3.
    Pete

  8. #8
    Join Date
    Apr 2014
    Location
    "Great North Wet"
    Posts
    133

    Default Re: Libreoffice Calc: track minimum of two cells

    Thanks Pete, I've been testing your suggestion and it works great!
    Turkey Creek Jack Johnson: Nobody move!
    Doc Holliday: Nonsense. By all means, move.

  9. #9
    Join Date
    Jun 2008
    Location
    Yorkshire
    Posts
    335

    Default Re: Libreoffice Calc: track minimum of two cells

    OK. Glad to be able to help.
    Pete

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •