Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 22:41:34 +0000



Post From: Need help with " Spreadsheet study "

[2014-10-08 00:58:44]
User48557 - Posts: 138
I just tried to recalculate and nothing is happening, the weird part is

=IF(AND(WEEKDAY(A3)=2,A4-INT(A4)<TIMEVALUE("08:30:00"),A3-INT(A3)>=TIMEVALUE("08:30:00")),B3,K4)

worked for me the first time I was punching it in, then I tried the new formula given for A Sunday Line and that didn't work at all, now that I'm going back and punching the old one in , neither of them work now. I have been trying to use different markets and charts and I'm getting nothing as far as any lines being drawn.