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
April 14, 2014
Accounting and Computer Science are among the new traditional undergraduate majors being offered at the Mesa branch campus.
Read More >>

April 10, 2014
Benedictine program helps students improve their English language skills
Read More >>

April 10, 2014
Raise your financial IQ at Benedictine University’s Money Smart Week seminar
Read More >>



Campus Calendar
Apr
22
Spring Graduation Fair
10:00 AM - 7:00 PM

Apr
22

Apr
22

Apr
23
Spring Graduation Fair
10:00 AM - 7:00 PM