Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 20:56:25 +0000



Post From: Spreadsheet help___repeating condition

[2014-06-22 19:49:14]
Sawtooth - Posts: 3993
Use a double IF statement, like this:

=IF(AA3>AA4,TRUE,IF(AA3<AA4,FALSE,P4))

Where the above formula is in cell P3, and the Highest High is in column AA.
Date Time Of Last Edit: 2014-06-22 20:43:45