0

I have a row of three cells with constantly changing values. Cell 4 I wish to display the lowest value ever achieved by any one of the 3 cells. By definition the value of cell 4 can only go down, not up.

Frank Boon
  • 1
  • 1

1 Answers1

0

I am not sure there is a simple way to achieve this using only Calc built in functions, but attach an event macro would do the trick.

Say your 3 cells are: B1, B2, B3

Then in B4 =min(B1:B3)

Then put an event trigger on B4 using a code similar to this post.

The trigger code in Modify_modified should check if B4 is smaller than B5. If it is, then write the new min value in B5.

H3coder
  • 158
  • 7
  • That level of coding is beyond my comprehension but I'm obliged for your response. – Frank Boon Jun 24 '22 at 06:39
  • As mentioned in many places, Stack Overflow is not supposed to be code writing service. I had already done too much in the mentioned post. That post and my suggestion in this post should have enough to get someone with coding knowledge to solving your problem. – H3coder Jun 24 '22 at 07:10