Simplify formulas
- From: "0-0 Wai Wai ^-^" <x@xxxxx>
- Date: Sun, 24 Jul 2005 00:08:05 +0800
I would like to simplify the following formulas
=SUM( LARGE(A1:A1000,{1,2,3...500}) )
Is it possible to simplify "{1,2,3...500}"?
Currently I need to type each number manually by myself, ie 1,2,3,4,5,6,7,8,9
and so on which is time-consuming.
Is there any expression which tells the computer that it's "from 1 to 500"?
--
Additional information:
- I'm using Office XP
- I'm using Windows XP
.
Relevant Pages
- Re: Simplify infinite series with Sines???
... use a square wave as well and I'd get the same result too. ... it makes it easier to simplify; then using a saw/square wave for k=2 ... this that it is equal to a sum. ... the coefficient aof z^i in P is ... (sci.math) - Re: Problem using solve... keeps busy
... However, if you then simplify() the result, you get a *large* ... Then at the end of the sum, there are a few lines of other terms ... and you simplifyafter substitution (applying the ... a=x into the original equation ... (comp.soft-sys.matlab) - Re: Some questions about simplification
... When I try to calculate sum of ... sines or cosines, the calculator makes calculation in approximation ... SEQ SigmaLIST SIMPLIFY>> ... (comp.sys.hp48) - Re: Prolog Programming for AI, problem 7.1
... but have run into a nasty exercise. ... Write a procedure 'simplify' to symbolically simplify summation ... % The idea is to calculate the numeric sum, ... % a list of the atoms in the compound expression, ... (comp.lang.prolog) - Re: Simplify formula for iterative programming
... character set is getting munged. ... >I wondered I anybody knew about analog simplifications to simplify H: ... >This simplied formula is much easier in iterative programming, ... If, as I guessing, your H is the sum over i,j of point distances from ... (comp.programming) |
|