Re: definition of a formula and function?

The entire thing is a formula.

When adding two cells as per your example you don't need the SUM function.

=A1+A2 is sufficient.

Use the SUM function for ranges.

=SUM(A1:A10)

=SUM(A1,D1,G1,L23)


Gord Dibben MS Excel MVP

On 5 May 2007 03:18:32 -0700, showsomeidnow <showsomeidnow@xxxxxxxxxxxxxx>
wrote:

i tried doing a search for this but am still unclear. if i have the
following for example:
=sum(A1+A2)

is SUM the function and (A1+A2) the formula? or is that too
simplistic.


Also, regarding variables if i have a list of, say, pupil data and a
convert this into a percentage is the pupil data INPUT variable and
the percentage(s) OUTPUT variable? again, is that too simplistic a way
of looking at things. thanks all.

.

Relevant Pages

  • Re: SUM
    ... the formula, or, you didn't really create that named range in the first ... Does the spelling of the range match what's in the formula? ... Click on the range name and you'll see the individual cells included in the ... > 30 arguments when using the SUM function without problems, ...
    (microsoft.public.excel)
  • Re: SUM
    ... > Click on the range name and you'll see the individual cells included in ... >> 30 arguments when using the SUM function without problems, ... >> exceeding the maximum number of characters allowed in a function (which ... >> now in a cell type ...
    (microsoft.public.excel)
  • Re: SUM
    ... if you use the SHIFT key then they're counted as one parameter ... ... 30 arguments when using the SUM function without problems, ... 29 cells but there were a lot of empty cells that I ... >> that you're selecting more than 30 as this could cause a problem. ...
    (microsoft.public.excel)
  • Re: #VALUE
    ... so I cant use the SUM function as it skips data in columns. ... Microsoft Excel MVP ... In both cases the inconsistent formula ... least one of the referenced cells contains a TEXT entry. ...
    (microsoft.public.excel.misc)
  • Re: how you get the sum by using the mouse
    ... Microsoft Excel MVP ... I used to be able to highlight an area of spreadsheet with the mouse and ... "COUNT=the number of cells with values within the chosen range" ... Its pretty annoying now as i found the SUM function better for my job ...
    (microsoft.public.excel.misc)