Q:

# What are examples of common Excel formulas?

A:

### Quick Answer

Some common Excel formulas include SUM, which calculates the sum of values within a specified range of cells, COUNT, which counts the number of cells that have characters or numbers in them, and INT, which eliminates the fractional part of a number. Another common formula is NOW, which displays the system date and time.

Continue Reading

## Keep Learning

Credit: Minerva Studio iStock Getty Images

### Full Answer

Excel users can manually enter formulas or insert functions, which are simply built-in formulas. The Insert Function button is usually under the Formulas tab. There are various types of functions, such as financial functions, logical functions, math functions and statistical functions. An example of a math functions is AVERAGE, which calculates the average of values in a specified range of cells. Some functions are only available in recent versions of Microsoft Excel.

IF, COUNTIF, SUMIF, ROUND and TODAY are more examples of commonly used Excel functions. IF tests for a true or false condition and returns a value, depending on state of the condition. The SUMIF function calculates the sum of a range of cells that meet a certain criteria. The COUNTIF function counts the number of cells in a range that meet a specific criteria. The ROUND function rounds a number off to a specific number of decimal places. As opposed to the NOW function, the TODAY function returns only the system date.

Learn more about Software
Sources:

## Related Questions

• A: To calculate the interquartile range in Microsoft Excel, first enter the values for which you want to calculate the interquartile range in one single colum... Full Answer >
Filed Under:
• A: Use of tutorials and guides that provide helpful instructions can help you learn to create Excel formulas, and practicing these spreadsheet tools reinforce... Full Answer >
Filed Under:
• A: Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is... Full Answer >
Filed Under:
• A: One disadvantage of Microsoft Excel is that users cannot enter numbers starting with "0" unless the field of the cell is changed from a number to text. Mac... Full Answer >
Filed Under:
PEOPLE SEARCH FOR