Difference between a formula and function for spreadsheets ?

Started by grey fox1 pages

Difference between a formula and function for spreadsheets ?

What IS the damn difference ?

I mean I always get confused on this , is .....

=sum(B3:F7) the formula or function ?

Or is ....

=(B3 + F7) the formula or function

Arghhhhhhh it pisses me off to no extent !!!

Re: Difference between a formula and function for spreadsheets ?

Originally posted by grey fox
What IS the damn difference ?

I mean I always get confused on this , is .....

=sum(B3:F7) the formula or function ?

Or is ....

=(B3 + F7) the formula or function

Arghhhhhhh it pisses me off to no extent !!!

=sum(B3:F7) <--- This calculates the sum from B3 to F7

=(B3 + F7) <--- This just adds B3 and F7

These are both functions.

Then whats a formula ?