I think that a simple definition with an example near the beginning would be great.Peter Kupfer wrote:
"=SUM(1, 2)" is a formula that uses the SUM function. A formula can contain multiple functions (where the result of one function becomes an argument of another function). Also, users often create formulas, but they rarely create new functions (I don't know if they can in OOo). Whether or not you explain the difference in the Calc guide, writers for it should understand the distinction and use the terms appropriately.Rick Barnes wrote:
IMO, this really isn't very important, perhaps a mention of it, but functionally (no pun intended) I don't see a real difference. Is there one?On Fri, 2005-04-15 at 04:13 -0400, Daniel Carrera wrote:
Uhhmm... what's the differnece? Most people who know those terms use them interchangably.
A formula is an expression like "=(4*3)+2" or "=A1+B1"...formulas begin with an equal sign that designates them as a formula.
A function is a predefined procedure that returns a value based on values (arguments or parameters) passed to it. Formulas can contain functions.
This could be made a little clearer, but they are not synonymous.
Something like
equation- a statement of equality between two quantities eg 0.3x = x - 4
function - a rule that states the relationship of one quantity to at least one other quantity eg y = 1 - x
formula- a rule or principle shown by symbols eg c = 2pi r
expression- symbol showing a mathematical process or quantity
Now these definition may not fit what is used in Calc ie function.
A very powerful computer operation which looks like an equation is not i = i - 1 If this can be used in Calc it needs to be explained.
Just my 2cents worth.
Chris
