Excel functions

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 the Excel Basic Tutorial column to learn!

The above is the detailed content of Excel functions. For more information, please follow other related articles on the PHP Chinese website!