Support Board
Date/Time: Sat, 11 Jan 2025 17:50:48 +0000
Post From: spreadsheet study
| [2016-12-13 08:48:50] |
| User553714 - Posts: 184 |
|
=IF(AND(AA3>=AB3, AH3>=AJ3, $E3=$H$1)=1, 1, 0) This should work, replay the chart and test; it's important for the reference to H1 to be absolute as you want the same value used everytime it is calculated. |