# Thread: Libreoffice Calc: track minimum of two cells

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

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

2. ## 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.

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

## Re: Libreoffice Calc: track minimum of two cells

Originally Posted by peteh100
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

4. ## 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?

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

## Re: Libreoffice Calc: track minimum of two cells

Here is a sample spreadsheet illustrating the problem
http://nisquallyhighlands.net/Sample.ods

6. ## 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.

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

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

## Re: Libreoffice Calc: track minimum of two cells

Thanks Pete, I've been testing your suggestion and it works great!

9. ## Re: Libreoffice Calc: track minimum of two cells

OK. Glad to be able to help.

#### Posting Permissions

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