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
July 28, 2014
One-Stop-Shop: Benedictine event makes transferring quick and easy
Read More >>

July 25, 2014
Former U.S. Attorney General Gonzales shares legal strategy in scandals, crisis
Read More >>

July 23, 2014
BenU at a Glance provides overview of student experience at Benedictine
Read More >>



Campus Calendar
Jul
30
BenU Summer Volleyball Camp
9:00 AM - 4:00 PM

Jul
31
BenU at Mesa - Transfer Days
4:00 PM - 7:00 PM

Jul
31
BenU Summer Volleyball Camp
9:00 AM - 4:00 PM

Aug
1
BenU Summer Volleyball Camp
9:00 AM - 4:00 PM