I want to update a temperature in a spreadsheet as follows:

A1 = input temperature A2 = 95% of historical high temperature A3 = Alarm

A1 A2 A3
100 F 95F
110F 104.5F
115F 109.25F
110F 109.25F
109F 109.25F ALARM

Note as A1 (the temperature) goes up A2 goes up but when A1 goes down A2 stays at the higher value.

When A1 goes below A2 A3 = “ALARM”

I have it working except I can not get A2 to stay at the higher value. Everything I try gives me a syntax error.

If you can help thank you, if not thank you anyway.