Support Board
Date/Time: Wed, 02 Jul 2025 12:09:55 +0000
Post From: Spreadsheet question
| [2020-04-13 03:19:17] |
| Sawtooth - Posts: 4231 |
|
P1 is a time value, like this: 14:15:00 If P1 is a DateTime value, use this formula: =IF(AND($P$1>=A3,$P$1<A2),B3,P4) but this will only return one value because P1 is only one day, and only if that day is within the range of the spreadsheet sheet. The formula uses A3 and A2 so that the returned value is in the correct row. |