Simplify formulas



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)