Support Board

Date/Time: Mon, 25 Nov 2024 18:24:09 +0000

Post From: Question about a spreadsheet study that references time and draws a line

[2024-02-15 14:24:08] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
Try this in K3: =IF(FRACTIME(MROUND(A3,1/86400))=TIMEVALUE("18:00:00"),C3,IF(FRACTIME(MROUND(A3,1/86400))>=TIMEVALUE("18:59:59"),0,K4)) The previous row didn’t make sense in this context The previous row is the one you want to make persistent. The persistent value is released with a second IF statement. Date Time Of Last Edit: 2024-02-15 14:57:47