Examples of commonly used formulas
Examples of commonly used formulas
Common Conditional
Check if a number is greater than or less than another number
Create conditional formulas by using the IF function
Display or hide zero values
Look up values in a list
Common Date and Time
Add dates
Add times
Calculate the difference between two dates
Calculate the difference between two times
Convert times
Count days before a date
Insert Julian dates
Insert the current date and time in a cell
Show dates as the day of the week
Common Financial
Calculate a running balance
Create a multiplication table
Common Math
Add numbers
Calculate the average of numbers
Calculate the difference between two numbers as a percentage
Calculate the median of a group of numbers
Calculate the smallest or largest number in a range
Convert measurements
Count cells that contain numbers
Count numbers greater than or less than a number
Divide numbers
Hide error values in a cell
Increase or decrease a number by a percentage
Multiply numbers
Raise a number to a power
Round a number
Subtract numbers
Common Text
Change the case of text
Check if a cell contains text
Combine first and last names
Combine text and numbers
Combine text with a date or time
Compare cell contents
Count nonblank cells
Remove characters from text
Remove spaces from the beginning and end of a cell
Repeat a character in a cell
Count unique entries in a list
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- excel basics for finance boston college
- introduction to excel formulae and functions
- hints for locating accounting errors
- ap chemistry chapters 1 and 2
- examples of commonly used formulas
- mean— a mathematical average of a group of numbers
- using solver table to do sensitivity analysis
- factors multiples and remainders
- working systematically primary mathematics
Related searches
- 500 most commonly used words
- list of commonly used words
- most commonly used languages in the world
- words not commonly used anymore
- the most commonly used words
- 1000 most commonly used english words
- commonly used words list
- commonly used english words list
- most commonly used words in english
- most commonly used words list
- 4000 most commonly used words
- 1000 commonly used words