Re: definition of a formula and function?

the entire equation is the formula, you are using the
SUM Work*** Function, which is a builtin function.

You most have been using Lotus 1-2-3 or something
because all you should be using is =A1+A2
(which would add two items in the same column)

If you installed a function as opposed to being a
builtin function that comes with Excel, it would also
be a function but would more correctly be identified
as a User Defined Function (UDF).

To give you an idea of a UDF see GetFormula on
my http://www.mvps.org/dmcritchie/excel/formula.htm
webpage. The instructions to install are at the top
of that page, but basically you might start at
http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro
if you have a macro or function code to be installed.

When you start installing macros and functions
you might want to check over Chip Pearson's page
on the difference between a Macro and a Function
http://www.cpearson.com/excel/differen.htm

Second part of your question:
Concerning INPUT and OUTPUT variables, I think you
have been shown some macro coding (VBA), though
those are not terms I've seen because that would be
usage rather they a types of variable.

I see in Google Groups archives that you have replies
none of which I see in my newsreader (OE), this seems
to happen more often for those who post original message
from Google Groups rather than connecting directly to the
newsgroup servers at Microsoft, where these groups
reside. The replies I see only in GG are olne from Dom Ciccone,
one from yourself, and one from Gord Dibben all on May 5
(at least in my time zone). I see other threads from you
that all have replies.

The thread as seen in archives
http://groups.google.com/groups?threadm=1178360312.662120.80470%40n59g2000hsh.googlegroups.com

Posting directly to Microsoft newsgroups:
http://www.mvps.org/dmcritchie/excel/posting.htm#postdirect

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"showsomeidnow" <showsomeidnow@xxxxxxxxxxxxxx> wrote in message news:1178360312.662120.80470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.




.