Support Board
Date/Time: Wed, 27 Nov 2024 00:41:11 +0000
Post From: Spreadsheet help___repeating condition
| [2014-06-22 19:49:14] |
| Sawtooth - Posts: 4120 |
|
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
|