Support Board

Date/Time: Sun, 06 Jul 2025 15:32:02 +0000

Post From: Getting a #value! error...

[2019-03-22 15:08:27] Link To Thread - Link To Post [Go To First Post]
User917679 - Posts: 76
I put this simple piece of code through my spreadsheet..: AND(ID25.SG1@4:ID25.SG1@29>ID25.SG4@4:ID25.SG4@29,ID51.SG1@4:ID51.SG1@29>ID51.SG4@4:ID51.SG4@29,ID68.SG1@4:ID68.SG1@29>ID68.SG4@4:ID68.SG4@29) From this alone(maybe spreadsheet settings too idk), is it possible to determine what could be the cause of a #value error here? Edit: I tried to make my code more efficient(as opposed to writing everything out full form), and it seems that the range function I'm using is incompatible with "AND()" ? In this case I'm abbreviating: // Heiken-Ashi #1,#2, and #3 are to EACH show 26 red signals in a row before a sell open is issued Date Time Of Last Edit: 2019-03-22 22:36:42