Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 15:39:52 +0000



Post From: VALUE! error

[2014-02-09 15:50:10]
Sawtooth - Posts: 4120
You'll get a #VALUE! error if there are no data in columns that the CROSSFROMBELOW function references.

Scroll the spreadsheet to the right and see what columns your study is outputting data to. You may need to edit the formula to reference the correct columns, or rearrange the order in the Studies to Graph list.

Studies output to columns AA and above (when the default Number of Formula Columns is 16). If you add, remove, or rearrange studies in the Studies to Graph list, the output columns will change.