1

What are some examples of formulas and functions?

edit

• cells

asked 2023-05-19 18:31:12 +0000

woof
21 ●1 ●1

edit retag flag offensive close merge delete

add a comment

0

answered 2023-05-19 18:49:02 +0000

bukephalos
21 ●4 ●3

1. SUM – calculates the sum of a range of cells
2. IF – checks whether a condition is met, and returns one value if true, and another value if false
3. AVERAGE – calculates the average of a range of cells
4. MAX – returns the highest value in a range of cells
5. MIN – returns the lowest value in a range of cells
6. COUNT – counts the number of cells containing numerical data in a range of cells
7. CONCATENATE – combines the content of multiple cells into a single cell
8. TODAY – returns the current date
9. VLOOKUP – searches for a value in a table, and returns a corresponding value in the same row
10. PMT – calculates the periodic payment for a loan with a constant interest rate and fixed term.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss