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.


Announcements
7/20/16
Interfaith Holiday Calendar 2016-17

4/7/16
Chicago Bilingual Nurse Consortium Features Ben U BSN Student

10/25/13
Announcements



News
September 26, 2016
Temptations to bring back sounds of Motown at Benedictine
Read More >>

September 23, 2016
Alumnus attributes success in career, life to one word: balance
Read More >>

September 23, 2016
BenU visiting scholar will discuss race and rebellion in America
Read More >>



Campus Calendar
No Events To Display