|
| Groups | Results 1 - 43 of about 43 for unary group:*excel author:j.e.. |
Sort by relevance Sorted by date | |||||||||
| |||||||||
| Excel Microsoft.com/Office2007 Number Crunching Could be Exciting. Learn More About Office 2007. |
je mcgimpsey jemcgimp...@mvps.org microsoft public mac office excel in article ... one way: =--(rand()>0.53) the double unary negative ("--") coerces the ... http://groups.google.com/g/c0a7ff05/t/.../d/23ae6ad2b99bcce?hl=en&ie... |
je mcgimpsey jemcgimp...@mvps.org microsoft public mac office excel in article ... one way: =--(rand()>0.53) the double unary negative ("--") coerces the ... http://groups.google.com/g/c0a7ff05/t/.../d/23ae6ad2b99bcce?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public mac office excel In article ... Harvey Waxman <hnwax...@gmail.com> wrote: So the unary minus is used when ... http://groups.google.com/g/c0a7ff05/t/.../d/144a235c5185cab9?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public mac office excel In article ... rather unaccountably, a pet peeve: using two unary minus operators, ... http://groups.google.com/g/c0a7ff05/t/.../d/c0bee708c733e52?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions The double unary does *not* do the same thing as multiplying the arrays, ... http://groups.google.com/g/7097feea/t/.../d/781e2ab9ef1cc38?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions Unary minus (-) converts inverts ... The second unary minus restores the sign. ... http://groups.google.com/g/7097feea/t/.../d/c1e43ed227e38041?hl=en...8... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc Try: =SUMPRODUCT(- -(A1:A1000)) SUMPRODUCT requires a numeric argument, so the double unary ... http://groups.google.com/g/2cf7ff05/t/.../d/d943fdb0e26c5b29?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions ... The + is just a superfluous unary plus character that is typically inserted ... http://groups.google.com/g/7097feea/t/.../d/36dd342b7c73e040?hl=en... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions The ... negative seven is a number, the negation of seven is a unary operation, ... http://groups.google.com/g/7097feea/t/.../d/daa47ea4df3fd9da?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions The importance of the double unary minuses is simply an efficient way to ... http://groups.google.com/g/7097feea/t/.../d/9a8e29674b06e111?hl=en...8... |
JE McGimpsey jemcgimp...@mvps.org microsoft public mac office excel In article ... Interestingly (at least to me), the unary minus is an operator in XL: ... http://groups.google.com/g/c0a7ff05/t/.../d/2864eb21382a3fb2?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc The "--" (double unary minus) will coerce the text to numbers/times, so if you included them, ... http://groups.google.com/g/2cf7ff05/t/.../d/2eddef6d8a7788ee?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions Correction: With multiple terms, one only need use at least one unary minus per ... http://groups.google.com/g/7097feea/t/.../d/963cbdb9c8033ce5?hl=en...8... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions ... posts which use the unary operators "--" before implementing some function. ... http://groups.google.com/g/7097feea/t/.../d/f495fff390cff7bd?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc note: there's no need to use the double unary minus if you're going to use the + operator. ... http://groups.google.com/g/2cf7ff05/t/.../d/e39b3811c902fd7d?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions One ... A2 If instead Set1 has numeric values, 200503, then use two unary minus ... http://groups.google.com/g/7097feea/t/.../d/faee9737380c8580?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions see ... What I don't understand of the use iof the -- unary operators. ... http://groups.google.com/g/7097feea/t/.../d/580c611463323719?hl=en... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc SUMPRODUCT ... One unary minus operator coerces the TRUE/FALSE array to -1/0s, respectively. ... http://groups.google.com/g/2cf7ff05/t/.../d/702ebb86f2e333ad?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions ... C1:C1000) The double unary minuses convert the Boolean (TRUE/FALSE) values ... http://groups.google.com/g/7097feea/t/.../d/c915e8ef0dcbcac4?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc SUMPRODUCT requires numeric arrays. the double unary minus converts the True/False from ... http://groups.google.com/g/2cf7ff05/t/.../d/7e3294e9989b85df?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel programming XL does have rules. A unary minus, or negation, operator has higher precedence than the ... http://groups.google.com/g/8077ff07/t/.../d/5f475ae8118d9376?hl=en...8... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel newusers Not the ... The most efficient way to coerce the value is first to apply the unary minus ... http://groups.google.com/g/c1c7ff04/t/.../d/6c5e4ec024e469fc?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc Niggle: There's no need to use the unary minuses on the E1:E10 argument: ... http://groups.google.com/g/2cf7ff05/t/.../d/93f364e15b8810c1?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions ... Oh, and the rationalization will be something along the lines of 'unary ... http://groups.google.com/g/7097feea/t/.../d/4f2411107dbd1701?hl=en... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet ... range RNG as =SUMPRODUCT(-ExtCell("Bold",RNG,1),RNG) Need double unary minuses here. ... http://groups.google.com/g/7097feea/t/.../d/b432d1ffcc191258?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet ... The first of the double unary minuses coerces TRUE/FALSE to -1/0, respectively. ... http://groups.google.com/g/7097feea/t/.../d/af6a1919bdbe8658?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions The first of the two ... The second unary minus sign converts -1/0 to 1/0. ... http://groups.google.com/g/7097feea/t/.../d/d8f0d2fac78c3f36?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public mac office excel In article ... You could multiply by 1, add 0 or use two unary minuses. ... http://groups.google.com/g/c0a7ff05/t/.../d/b513f59b5c9878d6?hl=en...8... |
JE McGimpsey jemcgimp...@mvps.org microsoft public mac office excel In article ... The double unary minus first coerces each element of that array to -1/0s, ... http://groups.google.com/g/c0a7ff05/t/.../d/9fc509d5a814b414?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel The first thing you're ... is that the unary minuses coerce the boolean TRUE/FALSE values to 1/0. ... http://groups.google.com/g/4027fefd/t/.../d/f1972acd13d40a3d?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel There is no automatic simplification in XL (other than eliminating unneeded unary +'s). ... http://groups.google.com/g/4027fefd/t/.../d/4743f4c62d881598?hl=en...8... |
JE McGimpsey jemcgimp...@mvps.org microsoft public mac office excel In article ... The benefit to coercing numbers from text to numeric using double unary ... http://groups.google.com/g/c0a7ff05/t/.../d/68a08f610c4d38e8?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel programming You're ... first unary minus coerces the boolean value to -1 for TRUE and 0 for FALSE. ... http://groups.google.com/g/8077ff07/t/.../d/788c66d61f4cc640?hl=en...8... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions Perhaps. No need to use the double unary minuses in the first term though, ... http://groups.google.com/g/7097feea/t/.../d/45dd48a83dffa795?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions Bob - A "unary +" doesn't coerce anything. + is a binary operator only in XL, ... http://groups.google.com/g/7097feea/t/.../d/84af334af9a595fc?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc Could probably get ... (but far be it from me to recommend not using a double unary minus! ... http://groups.google.com/g/2cf7ff05/t/.../d/31c00373c77699c?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions yes - there is no unary plus operator You can see that when you enter something ... http://groups.google.com/g/7097feea/t/.../d/c5589004eaae90a4?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc one way: ... It expects numeric arrays, which is why the unary minuses are used (to coerce ... http://groups.google.com/g/2cf7ff05/t/.../d/e929df302f3940ef?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel misc RIGHT(A1,1) will ... You can coerce the string to a number using a unary minus operator. ... http://groups.google.com/g/2cf7ff05/t/.../d/86595a7e1f626d81?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions ... I prefer to use the unary minus operator, which is more tightly bound and ... http://groups.google.com/g/7097feea/t/.../d/9eec1cbeb18ce9d0?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel worksheet functions ( LEFT(range ... The second unary minus operator converts -1 to +1 for the SUM. ... http://groups.google.com/g/7097feea/t/.../d/77c5f59497a9a343?hl=en&ie... |
JE McGimpsey jemcgimp...@mvps.org microsoft public excel Did you try it? ... arrays are explicitly coerced to numeric via the double unary minus operators. ... http://groups.google.com/g/4027fefd/t/.../d/cde6fba07fefb749?hl=en&ie... |
JE McGimpsey jemcgimp...@mcgimpsey.com microsoft public mac office excel In ... in column B: =SUMPRODUCT(--(A1:A100=1),--(B1:B100=2)) The double unary minus ... http://groups.google.com/g/c0a7ff05/t/.../d/3118dadf31292263?hl=en...8... |
| Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy |
| ©2009 Google |