2011
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.
=ROUNDUP(A2,0)
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
=RIGHT(A2,4)
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.


News
March 19, 2015
Making business meetings more productive topic of lecture, workshop at Benedictine
Read More >>

March 17, 2015
Benedictine's National Moser Center in Springfield hosts informational open house for adult students on April 8
Read More >>

March 16, 2015
Carroll will preside over first-ever Commencement at Mesa and deliver Lisle address before he steps down as University president
Read More >>



Campus Calendar
Apr
12
Spring Open House Session Two
12:00 PM - 3:00 PM

Apr
18
Saturday Preview Day
9:00 AM - 12:00 PM

Apr
23
Admitted Student Day
9:00 AM - 3:00 PM

May
9
Saturday Preview Day
9:00 AM - 12:00 PM