Timeline for Is my barcode valid?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 24, 2017 at 16:59 | comment | added | Wernisch | Problem is how Excel interprets =(A1:H1): This is not handled as an array. Is invalid if placed in any column not in A-H range. If placed in a column in A-H, returns the value for that column only. (Formula in % results in %: C2 --> C1 H999 --> H1 K1 --> #VALUE!) | |
| Nov 24, 2017 at 16:43 | comment | added | Wernisch | @RosLuP, Apologies, missed the changed ()s in your comment. | |
| Nov 24, 2017 at 16:37 | comment | added | user58988 | I want only to say that seems that in APL goes well doing first y= (A1:H1)+2*(A1+C1+E1+G1), and after the sum and the mod; in APL not goes well first sum(A1:H1) etc something as (1,2,3)+4=(5,6,7) and than sum(5,6,7)=18; note that sum(1,2,3)=6 and 6+4=10 different from 18. But possible I make error in something | |
| Nov 24, 2017 at 10:15 | comment | added | Wernisch | @RosLuP, not predefined, no. But Modulo, Sum, + etc do ;-) | |
| Nov 23, 2017 at 21:40 | comment | added | user58988 | =MOD(SUM((A1:H1)+2*(A1+C1+E1+G1)),10)=0 this formula exist in Excel? | |
| Nov 16, 2017 at 14:15 | history | answered | Wernisch | CC BY-SA 3.0 |