MindMap Gallery Formulas and functions
This is a mind map about formulas and functions, and its main contents include: common questions, important functions, application functions, reference names, and creation of formulas. Provides comprehensive guidance to users.
Edited at 2025-03-06 21:06:42Rumi: 10 dimensions of spiritual awakening. When you stop looking for yourself, you will find the entire universe because what you are looking for is also looking for you. Anything you do persevere every day can open a door to the depths of your spirit. In silence, I slipped into the secret realm, and I enjoyed everything to observe the magic around me, and didn't make any noise. Why do you like to crawl when you are born with wings? The soul has its own ears and can hear things that the mind cannot understand. Seek inward for the answer to everything, everything in the universe is in you. Lovers do not end up meeting somewhere, and there is no parting in this world. A wound is where light enters your heart.
Chronic heart failure is not just a problem of the speed of heart rate! It is caused by the decrease in myocardial contraction and diastolic function, which leads to insufficient cardiac output, which in turn causes congestion in the pulmonary circulation and congestion in the systemic circulation. From causes, inducement to compensation mechanisms, the pathophysiological processes of heart failure are complex and diverse. By controlling edema, reducing the heart's front and afterload, improving cardiac comfort function, and preventing and treating basic causes, we can effectively respond to this challenge. Only by understanding the mechanisms and clinical manifestations of heart failure and mastering prevention and treatment strategies can we better protect heart health.
Ischemia-reperfusion injury is a phenomenon that cellular function and metabolic disorders and structural damage will worsen after organs or tissues restore blood supply. Its main mechanisms include increased free radical generation, calcium overload, and the role of microvascular and leukocytes. The heart and brain are common damaged organs, manifested as changes in myocardial metabolism and ultrastructural changes, decreased cardiac function, etc. Prevention and control measures include removing free radicals, reducing calcium overload, improving metabolism and controlling reperfusion conditions, such as low sodium, low temperature, low pressure, etc. Understanding these mechanisms can help develop effective treatment options and alleviate ischemic injury.
Rumi: 10 dimensions of spiritual awakening. When you stop looking for yourself, you will find the entire universe because what you are looking for is also looking for you. Anything you do persevere every day can open a door to the depths of your spirit. In silence, I slipped into the secret realm, and I enjoyed everything to observe the magic around me, and didn't make any noise. Why do you like to crawl when you are born with wings? The soul has its own ears and can hear things that the mind cannot understand. Seek inward for the answer to everything, everything in the universe is in you. Lovers do not end up meeting somewhere, and there is no parting in this world. A wound is where light enters your heart.
Chronic heart failure is not just a problem of the speed of heart rate! It is caused by the decrease in myocardial contraction and diastolic function, which leads to insufficient cardiac output, which in turn causes congestion in the pulmonary circulation and congestion in the systemic circulation. From causes, inducement to compensation mechanisms, the pathophysiological processes of heart failure are complex and diverse. By controlling edema, reducing the heart's front and afterload, improving cardiac comfort function, and preventing and treating basic causes, we can effectively respond to this challenge. Only by understanding the mechanisms and clinical manifestations of heart failure and mastering prevention and treatment strategies can we better protect heart health.
Ischemia-reperfusion injury is a phenomenon that cellular function and metabolic disorders and structural damage will worsen after organs or tissues restore blood supply. Its main mechanisms include increased free radical generation, calcium overload, and the role of microvascular and leukocytes. The heart and brain are common damaged organs, manifested as changes in myocardial metabolism and ultrastructural changes, decreased cardiac function, etc. Prevention and control measures include removing free radicals, reducing calcium overload, improving metabolism and controlling reperfusion conditions, such as low sodium, low temperature, low pressure, etc. Understanding these mechanisms can help develop effective treatment options and alleviate ischemic injury.
Formulas and functions
Create a formula
Understand the formula
The formula always starts with "=", and the calculation results are displayed in the cell
The formula contains references, constants and various operators for cells
Input, modify and delete formulas
Filling Formula
Relative, absolute, and mixed references of cells
Relative reference, absolute reference and mixed reference: Relative reference is calculated based on the relative position of the target cell and the cell where the calculation object is located (the relative position remains unchanged); when you need to circle the range, add "$" under the English half-angle to the rows and columns of the range to lock, which is an absolute reference; when only rows or columns are locked, it is called mixed reference
Quote name
Syntax Rules
Understand the syntax rules of names (uniqueness, valid characters, other restrictions)
Define a name
Quickly define names, convert row and column titles to names, define names using the New Name dialog box
Select the range, enter the name you want to define in the name box in the upper left corner, and press Enter to complete the definition.
Selected content scope, (Formula) tab, (Defined name) group, Create from selected content
Quote name
Reference through the Name Box, reference in formula, change or delete a name
(Formula) Tab, (Defined Name) Group, Name Manager
Application functions
Understand functions
Functions are usually expressed as: function name (【parameter 1】, 【parameter 2】...)
category
Financial functions, date and time functions, mathematical and trigonometric functions, statistical functions
Find and reference functions, database functions, text functions, logic functions, information functions
Engineering functions, compatibility functions, cube functions, web functions
Input function
Memorize the input of formulas, select the insert function in the (formula) tab, select the function in the (function) group, modify the function
Important functions
Common functions
Ask for sum
SUM, SUMIF, SUMIFS
average
AVERAGE, AVERAGEIF, AVERAGEIFS
count
COUNT (only count the number of cells [right-aligned]), COUNTA (counting the number of non-empty cells), COUNTIF (counting the number of cells that meet the conditions in the cell), COUNTIFS (counting the number of cells that meet multiple conditions in the cell)
math
ABS (absolute value), INT (rounded down: the largest integer smaller than the original number), ROUND (rounded by rounding function, after all, the parameters represent the decimal digits after rounding), TRUNC (turned directly after the parameter is cut off, not rounded), CEILING (rounded up: the smallest integer larger than the original number)
text
CONCATENATE (used to concatenate two or more characters. Note that you should add an underscore such as (A1,"_", A2) in the middle of the two cell selection or use hyphens such as (A1&"_"&A2)), MID (such as MID (A1,m,n) refers to taking n characters from the mth character from the left to the right), LEFT (such as left(A1,n) means taking the first n strings in the A1 cell from the left), RIGHT (such as right(A1,n) means taking the first n strings in the A1 cell from the right), TRIM (removing the spaces at the beginning and ends of the string in the cell), LEN (calculating the length of the string in the cell)
date
NOW (such as now() can return the date and time of the current system), TODAY (such as now() can return the date of the current system), YEAR (picking the year from the cell representing the date), MONTH (picking the month from the cell representing the date), DAY (picking the date from the cell representing the date), WEEKDAY (calculates the day in the selected cell representing the week)
Ranking
RANK (RANK.EQ and RANK.AVG) (ranks data ascending and descending order)
Most worthwhile
MAX,MIN
Query
VLOOKUP (First: find the column where the data object is located; second: find the column where the data object is located is the first column in the range, and the data to be searched is the last column; third: enter 6 in the column of the framed range, such as the sixth column; fourth: exact match or approximate match, generally exact match, that is, FALSE)
logic
IF (If the parameter one condition is X<100, parameter two is not passed, and parameter three bits pass, that means that the display result is parameter two, and if the condition is not met, it is parameter three)
Other functions
ISEVEN (judging whether a number is even), ISODD (judging whether a number is odd), MOD (judging whether a number is odd), Parameter 1 is the divisor, Parameter 2 is the divisor, the result is the remainder after division, so that it can be judged whether it is an odd number), AND (logical operation function, indicating "logic and "such as =IF(AND (cell 1>=60, cell 2>=60,"No","Yes") means that the output is no when two conditions are met, as long as one of them is not met, it is output as yes), OR (logical operation function, indicating "logic or "such as =IF(OR (cell 1>=60, cell 2>=60,"No","Yes") means that the output is no when one of them is met, and if neither is satisfied, it is output as yes), WEEKDAY, INDEX, MATCH, etc.
Frequently Asked Questions
Common Errors
### (Cell column width is not enough), #DIV/0! (Divid not divide by 0), #NUM! (Formula is meaningless), #NAME? (no formula or no English half-width is used), #VALUE1 (parameter type is wrong), #NULL! (intersection is empty), #REF! (The original cell was deleted), #N/A (data does not exist in the selected area)
Correct the error
Open the (Formula) tab, Error Checking or Monitoring Window in the (Formula Audit) group
Recycle reference
Locate and correct circular references and change the number of times Excel iterates formulas. The circular reference works (files, options, formulas)
Tracking citations
Show the reference and reference relationship of formulas in a certain cell (select the cell to be queryed, click the (Formula) tab, "Tracking reference cell" or "Tracking subordinate cell" in the (Formula Review) group), view all reference relationships of the worksheet (select one cell at will, select all, click the (Formula) tab, and "Tracking reference cell" in the (Formula Review) group)