Home |
Search |
Today's Posts |
#1
|
|||
|
|||
what is function vs. formula?
my question is what is function vs. formula?
I need to know so that I can study for finals. I'm trying to get as much information as I can on the subject so that I may possibly get a good grade |
#2
|
|||
|
|||
francine
Formulas can use Functions or not. Functions have to be used in formula mode. This is a formula =A1+A2+A3+A4+A5+A6+A7 This is a formula with a Function in use =SUM(A1:A7) which saves you a lot of typing. Gord Dibben Excel MVP On Tue, 1 Mar 2005 15:17:03 -0800, "francine" wrote: my question is what is function vs. formula? I need to know so that I can study for finals. I'm trying to get as much information as I can on the subject so that I may possibly get a good grade |
#3
|
|||
|
|||
A formula contains one or more operators.
eg. 1+1 (the + is the operator) A function returns one value =SUM(1, 2, 3, 4) -- Rob van Gelder - http://www.vangelder.co.nz/excel "francine" wrote in message ... my question is what is function vs. formula? I need to know so that I can study for finals. I'm trying to get as much information as I can on the subject so that I may possibly get a good grade |
#4
|
|||
|
|||
The statement below is not entirely true.
Actually, Functions do not have to be used only in Formulas. A Function can be called by VBA code also. A couple of examples.........one with a User Defined Function........... Sub foo() MsgBox "The row height is " & rowht(ActiveCell) End Sub Function rowht(x) Application.Volatile rowht = x.RowHeight End Function One using an Excel Function............ Sub foo2() MsgBox "The Total is " & Application.WorksheetFunction.Sum(Range("A1:A32")) End Sub Gord Dibben Excel MVP On Tue, 01 Mar 2005 18:35:09 -0800, Gord Dibben <gorddibbATshawDOTca wrote: francine Formulas can use Functions or not. Functions have to be used in formula mode. This is a formula =A1+A2+A3+A4+A5+A6+A7 This is a formula with a Function in use =SUM(A1:A7) which saves you a lot of typing. Gord Dibben Excel MVP On Tue, 1 Mar 2005 15:17:03 -0800, "francine" wrote: my question is what is function vs. formula? I need to know so that I can study for finals. I'm trying to get as much information as I can on the subject so that I may possibly get a good grade |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function of "+" in the formula "=+(B19/50)*B10 | Excel Discussion (Misc queries) | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
Function Formula is displayed not results | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |