Certainly! Here's a consolidated list of the formulas we've covered so far:
1. SUM: =SUM(cell1:cell2)
2. AVERAGE: =AVERAGE(cell1:cell2)
3. COUNT: =COUNT(cell1:cell2)
4. MAX: =MAX(cell1:cell2)
5. MIN: =MIN(cell1:cell2)
6. IF: =IF(logical_test, value_if_true, value_if_false)
7. VLOOKUP: =VLOOKUP(lookup_value, table_range, column_index, [range_lookup])
8. CONCATENATE: =CONCATENATE(text1, text2, ...)
9. TODAY: =TODAY()
10. LEFT: =LEFT(text, num_chars)
11. RIGHT: =RIGHT(text, num_chars)
12. LEN: =LEN(text)
13. MID: =MID(text, start_num, num_chars)
14. TRIM: =TRIM(text)
15. UPPER: =UPPER(text)
16. LOWER: =LOWER(text)
17. COUNTIF: =COUNTIF(range, criteria)
18. SUMIF: =SUMIF(range, criteria, [sum_range])
19. AVERAGEIF: =AVERAGEIF(range, criteria, [average_range])
20. CONCATENATE: =CONCATENATE(text1, text2, ...)
21. INDEX: =INDEX(range, row_num, column_num)
22. MATCH: =MATCH(lookup_value, lookup_array, [match_type])
23. IFERROR: =IFERROR(value, value_if_error)
24. ROUND: =ROUND(number, num_digits)
These formulas cover a wide range of tasks, from basic calculations to text manipulation and data lookup. Remember to adjust the inputs, ranges, and criteria according to your specific needs.
No comments:
Post a Comment