They can apply to an individual cell or to a range of cells, on the same spreadsheet,
or on another worksheet in the same workbook,
or on another worksheet in another workbook.
What is a function? components examples decision tools common functions help with functions
The same is true in Excel for Mac
What is a function? components examples decision tools common functions help with functions
=SUM(D4:D7)
means
equalsadd togetherthe contents ofcells D4 through D7
or
equalsD4+D5+D6+D7
if individual cells, use commas
=SUM(D2,D3,D5)
means
equalsaddD2 and D3 and D5
if a range of cells, use a colon
= SUM(F2:F4,F7:F17)
means
equalsaddF2 through F4 and F7 through F17together
What is a function? components examples decision tools common functions help with functions
Insert Function or fx function wizard or hit = and then the function draw down box. The Function dialog box has Function Category and Function Name plus a short explanation of what the function does.
The same is true in Excel for Mac
What is a function? components examples decision tools common functions help with functions
What is a function? components examples decision tools common functions help with functions
What is a function? components examples decision tools common functions help with functions
Copyright © R.E. Bergquist 2014- | Last Updated on | Powered by w3.css