Excel Formulas and Functions…

 © Roy Cox 2005 to 2013

Our Privacy & Cookie Policy

Microsoft Office Excel is used to store data and analyse numbers in all types of businesses. To do this we make use of Excel functions and Excel formulas which allow us to quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number or a count of the number of items in a list. Most people know how to use the common formulas, but there is a host of useful formulas that can be helpful in most businesses as well as more specific formulas.

Some Common Formulas

SUM(): Calculates the sum of a group of values

AVERAGE():Calculates the mean of a group of values

COUNT(): Counts the number of cells in a range that contains numbers

INT(): Removes the decimal portion of a number, leaving just the integer portion

ROUND(): Rounds a number to a specified number of decimal places or digit positions

IF(): Tests for a true or false condition and then returns one value or another

NOW(): Returns the system date and time

TODAY(): Returns the system date, without the time

SUMIF(): Calculates a sum from a group of values, but just of values that are included because a condition is met

COUNTIF(): Counts the number of cells in a range that match a criteria

Formula Basics

As with all Excel formulas the above formulas are prefixed by =, so ensuring Excel knows that a calculation is required. To use  formulas you need to use reference operators i.e. refer the formula to a cell or a group of cells by placing a Cell or range of cells in the brackets, e.g SUM(A1:A10) will total the numbers contained in the range A1:A10.