Excel is a very important software in office automation, and Excel functions are built-in functions in Excel. Excel functions include a total of 11 categories, including database functions, date and time functions, engineering functions, financial functions, information functions, logical functions, query and reference functions, mathematical and trigonometric functions, statistical functions, text functions and user-defined functions.
How to use functions in Excel?
Input function cell
Click cell C1, the edit bar appears
Cell editing
Press the "Edit Formula" button
, a "Formula Palette" will appear under the edit bar, and the "Name" box will turn into a "Function" button.
Press the arrow on the right end of "Function"
Open the function list box and select the required function;
Function list box
When the desired function is selected
, Excel 2000 will open the "Formula Palette". Users can enter the parameters of the function in this palette. After entering the parameters, the results of the function calculation will also be displayed in the "Formula Palette";
Press the "OK" button to complete
There is no required function in the list
You can click the "Other Functions" option to open the "Paste Function" dialog box, from which the user can select the required function , and then click the OK button to return to the Formula Palette dialog box.
After understanding the basic knowledge and usage of functions, please follow the author to find various functions provided by Excel. You can see all functions by clicking "Function" in the insertion bar.
Paste function list
Question
Condition: If the completion ratio Z<50%, then Z=0; if 50%≤Z<70% , then Z=Z; if Z≥70%, then Z=1;
Now it is known that the completion proportion Z=54%, then I use a function to express it in the excel table: =IF(Z<50% ,0,IF(50%<=Z<70%,Z,IF(Z>=70%,1))), why is the result FALSE?
When the completion ratio Z=71% When, the result is 1.
Answer
In the logical judgment of the if function in excel, the form 50%<=Z<70% is wrong
Can be solved with and
and(Z>=50%,Z<70%)
Your formula can be simplified to the following
= if(Z>=70%,1,if(Z>=50%,Z,0))
You can also use:
=IF(Z<0.5,0,IF( AND(Z>=0.5,Z<0.7),Z,1))
For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn to learn!
The above is the detailed content of Excel functions. For more information, please follow other related articles on the PHP Chinese website!