Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 16:15:04 +0000



Post From: New Spreadsheet SC version 1278 #VALUE!

[2015-07-29 02:48:41]
User80177 - Posts: 29
Why is the first formula an error?

Col W =AND(OR(CJ3<-25,CJ4<-25),AA3 = true)*D3 evaluates to #VALUE!

Col AA3 =AND(CN3>CN4,CN4<CN5,CN5<CN6) evaluates to FALSE

Col CJ3 = 0 from study

Col CJ4 = 130.5 from study

By the way, it would be useful to provide copy to clipboard from the Cell Detail window.

Thanks