Support Board
Date/Time: Sat, 08 Nov 2025 16:45:42 +0000
Post From: Getting a #value! error...
| [2019-03-22 15:08:27] |
| 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
|