IF Statements...continued

An if statement didplays a specific output based on the value of a particular cell.
For example, say you want to dislay the word "Yes" everytime the value in any of the cells in column A say "Edit-Base" or otherwise display the word "No".
The formula below is an example of the above query:
=IF(A2="Edit-Base","Yes","No")
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.

Read More..

Using IF Statements in MS Excel

An if statement didplays a specific output based on the value of a particular cell.
For example, say you want to dislay the word "No" everytime the value in any of the cells in column A say "Clean Version" or otherwise display the word "Yes".
The formula below is an example of the above query:
=IF(A2="Clean Version","No","Yes")
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.

Read More..

Using Minimum Formula ub Excel

=Min("A:A")
The formula above will find the cell with the minimum or lowest value in column A. It will also display this value.

Read More..

Using VLOOKUP Exact Match Formula in Excel

The theory for vlookups is as follows:
=VLOOKUP(cell reference, corresponding range of cells to link to, column number to output, false)
An example is as follows:
=VLOOKUP(A2,$C$2:$D$30,2,FALSE)
The formula above will link cell A2 to cells C2 to C30. Note the values in cells C2 to C30 must be the same type as the values in column A where cell A2 exists. The number 2 means that the data returnerd from the vlookup formula would be from the 2nd column to column C, which would be Column D.  The most appropriate data to use as the link reference or lookup cell reference would be unique identifiers. So column A and cells C2 to C30 would work perfectly with them both being customer id columns or employee id columns. That would be the most appropriate way to match any data.  The word: "False" means: Find an exact match.

Read More..

Using Maximum formula in Excel

=MAX("A:A")
The formula above will find the cell with the maximum or highest value in column A. It will also display this value.

Read More..

Using CountIF Formula in Excel

=CountIF(A:A,"Test")
The formula above will count the number of times the value Test appears in the whole of column A and also display the number.

Read More..

Using Sum Formula in Excel

=Sum("A:A")
The formula above will give you the total value of column A (e.g in the case that you have sales figures in column A). It will display this value.

Read More..