Support Board
Date/Time: Sun, 26 Oct 2025 22:12:58 +0000
Post From: Spreadsheet Formula
| [2025-02-22 16:11:59] |
| User431178 - Posts: 802 |
|
=IF(AND(BARTIME>=TIME(11, 01,0),BARTIME<=TIME(13,0,0),ID18.SG1,IF(BARTIME>=TIME(17,00,0),ID18.SG1,ID18.SG1))
You do not have the parentheses correct, count them, one set is not closed. Try this instead, noting that the AND condition is now closed. =IF(AND(BARTIME>=TIME(11, 01,0),BARTIME<=TIME(13,0,0)),ID18.SG1,IF(BARTIME>=TIME(17,00,0),ID18.SG1,ID18.SG1))
Date Time Of Last Edit: 2025-02-22 16:12:16
|