Common Excel Formulas

Common Excel Formulas

December 20, 2011

Looking for the correct syntax for common formulas in Excel? Look no further:

Syntax Description
=SUM(A1:A6) Adds up the cells from cells A1 through A6
=SUM(A6-A4) Subtracts A4 from A6
=AVERAGE(A1:A2) Calculates the average between cells A1 & A2

=IF(A2>B2, "True", "False")

 Compares two cells and returns "True" if A2 is greater than B2.
Rounds up A2 to the specified number of decimal places (0)
=UPPER(A2) Changes the text in A2 to UPPER CASE
=LOWER(A2) Changes the text in A2 to lower case
=PROPER(A2) Changes the text in A2 to Proper Case
 =CONCATENATE(A2," ",B2) Concatenates (strings together) cells such as a first name and last name
Displays just the last four characters from A2. For example, if A2 holds a Social Security Number, =CONCATENATE("***-**-",RIGHT(A2,4)) would show ***-**-1234
=TRIM(A2) Removes leading or trailing spaces from A2. But, if A2 has two words in it, the space between the two words is left intact.
='worksheet 2'!A2
Shows the value of cell A2 that's on "Worksheet 2" - use this to bring the value from a cell on another worksheet in the same file.
=TODAY() Inserts today's date

For more helpful hints, check out Examples of Commonly Used Formulas from Microsoft.

October 6, 2015
Event at Benedictine addresses role of corporations in curbing climate change

October 5, 2015
Benedictine’s new Goodwin Hall an innovative hub for business education

September 29, 2015
Benedictine boosts med school options for students with Ross University agreement

Campus Calendar
No Events To Display