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
May 27, 2015
Alumnus's career steeped in Benedictine values, willingness to learn new things
Read More >>

May 18, 2015
Benedictine University at Mesa graduates celebrate earning their degrees during school’s first-ever Commencement Convocation May 16 at Gillett Hall
Read More >>

May 15, 2015
BenU at Mesa students receive charter from Rotaract service organization
Read More >>



Campus Calendar
Jun
13
Saturday Preview Day
9:00 AM - 12:00 PM

Jun
23
Admitted Student Day
9:00 AM - 1:00 PM

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

Aug
13
Fall Transfer Orientation
10:00 AM - 1:00 PM