Commonly used formulas in excel.
Basic Math Formula:
Addition, subtraction, multiplication and division: Use the "+" or "" " operators for basic arithmetic calculations.
Sum): Find the sum of a series of numbers, e.g. =sum(a1:a10) to find the sum of cells a1 to a10.
Average Correlation Formula:
*erage: Calculate the average of a series of numbers, e.g. =**erage(a1:a10).
median: Gets the median of a set of numbers, such as =median(a1:a10).
Logical function: if(condition): Used to return a different value when the specified condition is met, such as =if(a1>10,)."yes", "no")。
and or: Used for multi-condition judgment.
Text processing functions:
concatenate: Merge the contents of multiple cells into one, such as =concatenate(a1,)." ", b1)。
Left, right, and mid: Used to extract some characters from the text.
Date and time functions:
Today and Now: Returns the current date or datetime.
Datedif: Used to calculate the number of days, months, or years between two dates.
Conditional Statistical Functions:
Countif and Sumif: Count or sum the value of a cell when the condition is met, such as =Countif(A1:A10,">10")。
Find and Reference:
Vlookup: Used to look up a value in a table and return its corresponding other values.
Hlookup: Similar to vlookup, but look horizontally.
These formulas provide Excel users with powerful tools to analyze, calculate, and process data based on different needs.