697 results for and function excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
The AND Function in WPS Spreadsheet02:56
The AND Function in WPS Spreadsheet
The AND function is one of the commonly-used logical functions. When we need to test multiple conditions, it can quickly return the results. It will return TRUE if all of the arguments evaluate TRUE. Otherwise, it will return FALSE as its result. The syntax is stated as follows: AND(logical1,logical2, ...)Logical 1 is the first condition, while logical 2 is the second condition to evaluate, and up to 255 arguments are allowed in AND Function. Take this table as an example. With the sal....
The INDEX function03:50
The INDEX function
The INDEX function can look up a value regarding its row and column numbers.There are two forms of the INDEX function, the Array form and the Reference form. · One: Array formWe'll use the Array form to return the value located in the seventh row and the fourth column.First, select cell J6. Next, click Formulas and then Insert Function to insert the INDEX function. The function syntax:INDEX(array,row_num,column_num)The first parameter, 'Array', refers to the array for valu....
The Trace Precedents function00:57
The Trace Precedents function
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of Tracking Precedents of WPS table.Take this table as an example. We want to see which cells are referenced by the formula of ....
AVERAGE function quickly average data00:57
AVERAGE function quickly average data
In WPS Spreadsheet, we can use the AVERAGE function to quickly find the average value of a set of data quickly. It is often used to calculate average wages, average sales, and so on. Take this table as an example. We now need to find the average sales of the bakery this week. After we click cell D4, click Insert Function, and enter AVERAGE in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up. The data we filled in Num....
Look up data quickly with LOOKUP function04:23
Look up data quickly with LOOKUP function
Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....
Use CONCAT function to merge data01:16
Use CONCAT function to merge data
We can use the CONCAT function to merge the contents of multiple cells.This function is mainly applied to merge character strings within a certain cell range or in different cells. Now we take a simple case as an example. We want to merge the domain names to form a complete website address.1. Click Formulas, click Insert Function, input "CONCAT" in the dialog, and click OK.2. Since the cells to be combined are continuous, we input "A2:D2" in Text 1, click OK, and drag the cell to fill ....
How to use the OR Function01:40
How to use the OR Function
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. This is a promotion application form submitted by employees. The company sets two conditions for it.1. Length of service should be more than 3 years; 2: Personal KPI should be rated as A.The Applicant has the qualification to register when any one of the requirements is met. If you are the HR of the company, how can you quickly select qualified employee....
Use COUNTIF function for conditional statistics01:32
Use COUNTIF function for conditional statistics
COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function? The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)Range is the cell range that meets the criteria.Criteria are the conditions that need to be counted.Now we have a table that records everyone's afternoon tea order information. Column B co....