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 23, 2014
Building for the future: Benedictine marks construction of new College of Business facility
Read More >>

April 23, 2014
Benedictine values, liberal arts education play important roles in health care, student success
Read More >>

April 14, 2014
Accounting and Computer Science are among the new traditional undergraduate majors being offered at the Mesa branch campus.
Read More >>



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

Apr
24
BenU at Mesa - Transfer Days
4:00 PM - 7:00 PM

Apr
24
Admitted Student Day
8:00 AM - 2:30 PM

Apr
27
AMSA 5K Race
9:00 AM - 11:00 AM