Using Weekday function in Excel

=Weekday(now())
The above formula will display the current day of the week. For example, if you entered this formula in a cell within excel on a Monday. Then the formula will display the word "Monday".

Read More..

Using Tomorrow date function in Excel

=today()+1
The excel formula above will display tomorrow's date within excel. So, if today was the 01/01/2014 the formula would display 02/01/2014.

Read More..

Year function

=year(now())
The excel formula above will display the current year as set on your computer.

Read More..

Month function in Excel

=month(now())
The excel formula above will give you a display of the current month in excel as set on your computer.

Read More..

Using Addition in Excel

=A2+B2
The formula above will add the value of cell A2 to the value of cell B2.

Read More..

Yesterday's Date Function in Excel

=today()-1
The formula above will give you yesterday's date.  It does this by subtracting one day from today's date.

Read More..

One week ago date function in Excel

=today()-7
The excel formula above will the date of 1 week ago. It will do this be subtracting seven days from todays date.

Read More..

Current Date Function in Excel

=today()
The formula above when inputted in excel will give you the current date as displayed on your computer.

Read More..

Absolute formula in Excel

The excel absolute formula returns the value of the referenced cell as a positive value whether it is positive or negative. So take the following two formulas: =ABS(20) will display the value 20. =ABS(-20) will also display the value 20.

Read More..

Division

=A2/B2
Using the foward slash as a division symbol...the formula above will divide the value in cell A2 by the value in cell B2.

Read More..

Multiplication in Excel

=A2*B2
Using the astrix, the formula above will multiply the value in cell A2 by the value in cell B2.

Read More..

Using Subtraction in MS Excel

=A2-B2
The formula above will subtract the value of cell B2 from cell A2.

Read More..

Date and Time function in Excel

=Now()
The formula above will extract the current date and time in excel of the computer it is on.

Read More..

Using IF Statements in MS Excel

An if statement didplays a specific output based on the value of a particular cell.   An else if statement displays more than one output...So it is not giving a yes or no answer, but several possible answers.
For example, say you want to dislay the word child for the age less than 18 and the word working adult for ages less than 65 and the word retired for ages equal to and over 65. Let us say column A has the range of ages.
The formula below is an example of the above query:
=IF(A2<18,"Child",IF(A2<65,"Working Adult","Retired"))
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.

Read More..

IF Search Statement (wildcard if statement)

An if search statement diplays a specific output based on a value that is embedded within a text string that contains other values.
For example, say you want to dislay the number 1.78 everytime the value in any of the cells in column A contains the value of 16:9 or otherwise display the word "Check Material". Let's also say an example text in cell A2 is "625 PAL - 16:9 WIDESCREEN"
The formula below is an example answer to the above query:
=IF(NOT(ISERROR(SEARCH("16:9",A2,1),1.78,"Check Material")
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.

Read More..

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..