Support Board
Date/Time: Sun, 22 Dec 2024 04:22:21 +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 |