Support Board
Date/Time: Thu, 06 Feb 2025 05:45:57 +0000
Post From: Spreadsheet question
| [2020-04-13 03:19:17] |
| Sawtooth - Posts: 4169 |
|
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. |