Ok so bin putting off making some Spreadsheet tutorials for ages now, so I thought id start off simple with some functions you can use in Microsoft Excel. These will work in everything above 2000 and most likely lower
If you have no idea what the hell these things are, dont worry a tutorial on how to implement them into your spreadsheet will be coming soon (as well as all the other tutorials ive promised.)
Ok so to the functions (enter super man smilie here
The ones you want to know
The Trickier Ones
To Be Completed
If you have no idea what the hell these things are, dont worry a tutorial on how to implement them into your spreadsheet will be coming soon (as well as all the other tutorials ive promised.)
Ok so to the functions (enter super man smilie here
The ones you want to know
Description
The sum function does what it says on the tin, it just sums cells and values together and gives you the answer. More cells or values can be added just by seperating all of them with a comma.
Template
=SUM(Cell1,Cell2)
Example
=SUM(G4,A2,6)
The sum function does what it says on the tin, it just sums cells and values together and gives you the answer. More cells or values can be added just by seperating all of them with a comma.
Template
=SUM(Cell1,Cell2)
Example
=SUM(G4,A2,6)
Description
The basically returns a value or other function depending on a cells critera.
Template
=IF(Cell Critera,If True,If False)
Example
=IF(D3>52,Expensive,Cheap)
The basically returns a value or other function depending on a cells critera.
Template
=IF(Cell Critera,If True,If False)
Example
=IF(D3>52,Expensive,Cheap)
Description
This returns the largest value in a range.
Template
=MAX(Value1,Value2...)
Example
=MAX(12,10)
=MAX(C2:F5)
This returns the largest value in a range.
Template
=MAX(Value1,Value2...)
Example
=MAX(12,10)
=MAX(C2:F5)
Description
This returns the smallest value in a range.
Template
=MIN(Value1,Value2...)
Example
=MIN(12,10)
=MIN(C2:F5)
This returns the smallest value in a range.
Template
=MIN(Value1,Value2...)
Example
=MIN(12,10)
=MIN(C2:F5)
Description
This returns the number of cells that contain a number.
Template
=COUNT(Value1,Value2...)
Example
=COUNT(C2:F5)
This returns the number of cells that contain a number.
Template
=COUNT(Value1,Value2...)
Example
=COUNT(C2:F5)
The Trickier Ones
Description
This returns the sum of a range of cells if a condition is met.
Template
=SUMIF(ConditionRange,Condition,CellsToBeSummed)
Example
=SUMIF(A1:A4,">6",B1:B4)
[attachment=58]
This returns the sum of a range of cells if a condition is met.
Template
=SUMIF(ConditionRange,Condition,CellsToBeSummed)
Example
=SUMIF(A1:A4,">6",B1:B4)
[attachment=58]
Description
This is a complex and confusing function and is hard to explain but ill try my hardest.
Basically this function returns a value from another table dependant on what value you entered into the current table.
See example for more details. The V in VLOOKUP stands for Vertical, the function looks up a value vertically.
Template
=VLOOKUP(CellsToBeChecked,TableToCheckForValues,ColumnOfCorrespondingValue)
Example
=VLOOKUP(B2:B5,F2:G5,2)
[attachment=84]
In this example;
I have entered the VLOOKUP code into the type column of the first table.
This is a complex and confusing function and is hard to explain but ill try my hardest.
Basically this function returns a value from another table dependant on what value you entered into the current table.
See example for more details. The V in VLOOKUP stands for Vertical, the function looks up a value vertically.
Template
=VLOOKUP(CellsToBeChecked,TableToCheckForValues,ColumnOfCorrespondingValue)
Example
=VLOOKUP(B2:B5,F2:G5,2)
[attachment=84]
In this example;
- CellsToBeChecked is the Code Column
- TableToCheckForValues is the complete table on the right
- ColumnOfCorrespondingValue is the second column of the right hand table.
I have entered the VLOOKUP code into the type column of the first table.
Description
This is the Horizontal version of VLOOKUP, because its basically the same there isnt a example for this one.
Template
=HLOOKUP(CellsToBeChecked,TableToCheckForValues,ColumnOfCorrespondingValue)
This is the Horizontal version of VLOOKUP, because its basically the same there isnt a example for this one.
Template
=HLOOKUP(CellsToBeChecked,TableToCheckForValues,ColumnOfCorrespondingValue)
Description
This is the most simplest version of a Lookup. In this function you identify everything the function needs to look for.
You can only enter one column in all of the entries in the function.
Template
=LOOKUP(ColumnOfCellsToBeChecked,ColumnOfCellsToCheckForValues,ColumnOfCorrespondingValue)
Example
=LOOKUP(G2:G8,B2:B5,C2:C5)
This is the most simplest version of a Lookup. In this function you identify everything the function needs to look for.
You can only enter one column in all of the entries in the function.
Template
=LOOKUP(ColumnOfCellsToBeChecked,ColumnOfCellsToCheckForValues,ColumnOfCorrespondingValue)
Example
=LOOKUP(G2:G8,B2:B5,C2:C5)
To Be Completed