Libreoffice speadsheet help

Sooler

lindabea wrote: »

Putting the formula in B3.... IF (B1>B2,B3) works fine as long as whenever I update B1 with a greater value. If I enter a lower value in B1, then B3 gets updated with zero. Logically, it's correct because the condition is false, so B3 is populated with the 'otherwise' value. Looks like I'm going to have to read up about macros

You only want B3 to update if B1 > B2 AND B1 > B3

=IF(AND(B1>B2,B1>B3),B1)

A further issue is when or what triggers B3 to recalculate.
Is recalculating B3 when either B1 or B2 updates what's required?

State 1)
B1=2
B2=1
B3=2

Expected state 2)
B1=400
B2=600
B3=2


To get from state 1 to 2, if you update B1 first
B1=400
B2=1
B3=400

then update B2
B1=400
B2=600
B3=400 .... 400 not 2


This may suggest you need to always update B2 first.