Use of the choose function
In Excel, the choose function was mainly used to select and return a value from a list of parameters. The grammar is Choose(index_num, value1, (value2),...). 1. ** Required parameters ** - **index_nums (required parameters)**: It is a numerical expression or field. The result should be a value between 1 and 254, or a formula or a reference to a cell containing a number between 1 and 254. If index_numis 1, the function returns value1; if index_numis 2, it returns value2, and so on. If index_nums is less than 1 or greater than the serial number of the last value in the list, the function returns the error value #DOWN!; If it was a small number, it would be rounded off before use. - **value1, value2,...**：Value1 is required, and subsequent values are available, ranging from 1 to 254. These parameters can be numbers, cell references, defined names, formulas, functions, or text. The function 'Choose', based on index_nums, chooses a value or an operation to be performed from these value parameters. If index_nam is an array, each value will be calculated when calculating the function. Moreover, the numerical parameters of the function could not only be a single value, but also a region reference. For example, the formula =SUM(ChoOSe(2,A1:A10,B1:B10,C1:C10)) is equivalent to =SUM(B1:B10). First, the reference B1:B10 returned by the ChoOSe function is calculated, and then the SUM function sums the values in the region B1:B10. 2. ** Usage scenario ** - ** Data column swap **: For example, in the formula =ChoOSe({1,2},B:B,A:A), you can swap the data of the two columns A and B. - ** Combined with Vlook up formula ** - ** Reverse Search Match **: The Vlook up formula can only search from left to right. If you want to search from right to left (for example, search for the employee number on the left by name), and the original data cannot be changed, you can use the choose function combination. For example, the formula =VLOOkUP(E2,ChoOSe({1,2},B:B,A:A),2,0). - ** Multi-criteria Match Search **: You can find a match based on two conditions without using auxiliary columns. For example, if you need to find a desired result based on two conditions, you can use the choose function formula combination. For example, the formula =VLOOkUP(E2&F2,ChoOSe({1,2},A:A&B:B,C:C),2,0). "Choose" was equally exciting. Everyone was welcome to read it!
How to use the choose function
The basic grammar of the function is: Choose(index_num, value1, [value2],...). The index_nam is a required argument. It is an integral number that is used to specify which value argument to select. Its value starts from 1. For example, if there are 5 values in the list, the valid range of index_numis 1 to 5. If index_nums is less than 1 or greater than the index number of the last value in the list, then CHOOSE returns #OUT! Wrong value; if index_nam is a decimal, it will be rounded off before use. Value1 is required, and the subsequent values are available. There are a total of 1 to 254 numerical parameters. According to index_nums, Choosewill select a value or an operation to be performed. The parameters can be numbers, cell references, defined names, formulas, functions, or text. For example, if the formula = CHOOSES (2,B2,B3,B4,B5), if "B2","B3","B4", and "B5" represent four regions, and the result is 2, that is, the second region is selected, and the return value is the contents of cell B3. The Choose function can also be used in conjunction with other functions, such as the Vlook up function to perform a reverse search: =VLOOkUP(E2, Choose({1,2},C:C,B:B),2,0); the Sum function to perform a column separation: =SUM(Choose({1,2,3},B:B,D:D,F:F)), etc. "Choose" was equally exciting. Everyone was welcome to read it!
How to use the choose function
The basic grammar of the function is: Choose(index_num, value1, [value2],...). 1. **index_number (Required)** - This is an entire number, and its value starts from 1. It is used to specify which value to choose. If there are 5 values in the list, the valid range of index_nam is 1 to 5. If index_nums is less than 1 or greater than the index number of the last value in the list, then CHOOSE returns #OUT! Wrong value; if index_nam is a decimal, it will be rounded off before use. For example, when index_numis 4, the function will return the value4; when index_numis 4.6, the function will still return the value4. 2. **value1, [value2],... (Value)** - Value1 is required, and subsequent values are available. There can be 1 to 254 numerical parameters. These parameters can be numbers, cell references, defined names, formulas, functions, or text. Choose will choose a value or an operation to perform based on index_num. However, unless the choose function is used as an array, it is not recommended to use a cell range for value. The following are some examples of specific applications: - ** Basic Usage **: For example, the formula = CHOOSES (2,B2,B3,B4,B5). Here, it is assumed that "B2","B3","B4", and "B5" represent four regions or values respectively. Since index_nam is 2, the returned value is the second region or value (this is the content of cell B3). - ** Reverse search with the VlookUp function **: When you need to find the corresponding amount based on the sales name, but the sales column you want to find is not in the first column of the search area, you can use the combination of the Choose function and the VLOOkUP function. For example,=VLOOkUP(E2,ChoOSe({1,2},C:C,B:B),2,0), ChoOSe({1,2},C:C,B:B) means to select the first region C:C, then select the second region B:B, and combine them into a search range. This can solve the reverse search problem. - ** Using the Sum function to calculate the sum across columns **: If you want to calculate the sum of all the products across columns, you can enter the function formula =SUM(Choise ({1,2,3},B:B,D:D,F:F)). First, select each column of the amount, and then use sum to calculate the sum. "Choose" was equally exciting. Everyone was welcome to read it!
How to use the table choose function
In a table (using Excel as an example), the grammar of the ChoOSe function is ChoOSe(index_num, value1, [value2],...). Its function was to select a value from a list of up to 254 values based on the index number. The following are some typical usages: ** 1. Transform date into quarter ** If column A is date data, to convert the date to the corresponding quarter, you can enter the formula in the corresponding cell (such as column B):= Choice (Month(A2),"1st quarter","1st quarter","1st quarter","2nd quarter","2nd quarter","3rd quarter","3rd quarter","4th quarter"). Take cell A2 as an example. Months (A2) will get the month number of the date in cell A2. This month number will be used as the index number, and the corresponding quarter string will be selected according to the settings in the formula. ** 2. Replacing the nesting of the IF function to determine the level ** If there is a comparison table of scores and grades (such as cells E1:F6), to determine the score level of each student in column A (the results are placed in column C), you can enter the formula in cell C2:=Choose((B2>=0)+(B2>=60)+(B2>=70)+(B2>=80)+(B2>=90),"E","D","C","B","A"). In this formula, the calculation result of (B2>=0)+(B2>=60)+(B2>=70)+(B2>=80)+(B2>=90) was used as the index number, and the corresponding level was selected according to the range of conditions that the score met. ** 3. Reverse query with the VLOOkUP function ** For example, if there was an employee information table A1:D8, one had to inquire about the employee number of a specified employee. You can enter the formula in the corresponding cell (such as G2):=VLOOkUP(F2,Choose({1,2},$B$1:$B$8,$A$1:$A$8),2,False). Here, Choise ({1,2},$B$1:$B$8,$A$1:$A$8) will generate a new array, with the B1:B8 "Name" column as the first column, and the A1:A8 "Work Number" column as the second column. Then the VLOOkUP function will use this new array as the search area to perform a reverse query. ** 4. Randomly select data from a specified range ** If you want to randomly select a name from the names in cells A2:A5, you can enter the formula in cell C2:=Choose(Randbeteen (1,4),A2,A3,A4,A5). Among them, Ran Between (1,4) would generate a random number between 1 and 4. This random number would be used as an index number to select a name from A2, A3, A4, and A5. In addition, you can also use the choose function to achieve the sum of the conditions of the region, or when you use the vlook up function to search for data and the search area is inconsistent with the usual search area, you can use the choose function to re-match the area to be found for reverse query and other operations. "Choose" was equally exciting. Everyone was welcome to read it!
choose function formula
In Excel, the basic grammar of the choose function was Choose(numerical number, first range, second range...). Its function was to select and return a value from the range list based on the number of values. For example, the formula =Choose(2,B2,B3,B4,B5), where "B2","B3","B4", and "B5" represented four regions. If the result of Choose was 2, which was the second region, then the final result would be the contents of cell B3. Index_numis a required argument. It can be a numerical expression or field. The result must be a number between 1 and 254, a reference to a cell containing a number between 1 and 254, or a formula. If Index_numis 1, the function "Choise" returns value1; if Index_numis 2, the function "Choise" returns value2, and so on. If Index_nums is less than 1 or greater than the sequence number of the last value in the list, the function Choose returns the error value #Worth!. If Index_numis a decimal number, it will be rounded off before use. Value1 is required, and the subsequent values are available. The number of these value parameters is between 1 and 254. The function Choise chooses a value or an operation to be performed from these value parameters based on Index_num. The parameters can be numbers, cell references, defined names, formulas, functions, or text. In addition, there are functions related to choose, such as ChooseCOLS, whose formula is = ChooseCOLS(Array, number 1, number 2...). The first argument is an array, followed by numbers, which means that the corresponding column number is extracted according to the number (For example, entering the formula =ChooseCOLS(A1:C8,1) will extract the first column result in the A1:C8 cells; entering the formula =ChooseCOLS(A1:C8,1,3) will extract the results of the first and third columns and then merge them together; if the number is filled in as a negative number, such as entering the formula =ChooseCOLS(A1:C8,-1,2),-1 means that the result of the first column is extracted from the right to the left). "Choose" was equally exciting. Everyone was welcome to read it!
choose function grammar
The choose function's grammar is "Choose"(index_num, value1, [value2],…). The index_nam is a required argument and is an integral number between 1 and 254.(It can be a numerical expression or the result of a field operation is a numerical value, or it can be a reference to a cell containing a number between 1 and 254, or a formula; if it is a decimal, it will be rounded off before use.). This value determines which of the values 1 and 2 will be returned by the function.(If index_numis 1, the function returns value1; if index_numis 2, it returns value2, and so on; if index_numis less than 1 or greater than the serial number of the last value in the list, it returns the error value #DOWN!). The value1 is required, and the subsequent values can be selected. The number of these value parameters is between 1 and 254. They can be numbers, cell references, defined names, formulas, functions, or text. "Choose" was equally exciting. Everyone was welcome to read it!
How to choose the TV function?
The choice of TV functions should be decided according to individual needs and preferences. First of all, he needed to be clear about his main purpose for using the television. If you were a movie fan and wanted a high-quality movie experience, you could choose a TV that supported 4K Ultra HD, a large screen, a borderless design, and a built-in sound system. If you like watching TV shows, the smart TV will become your good friend. You can choose a smart TV that supports various applications and voice control. In addition, some features could also be considered, such as support for HVR technology, high refresh rate, wide color range, and so on. Finally, don't forget to compare the functions and performance of different brands and choose the TV that suits you.
Choose Function in R Language
In R, the choose function was a very basic and important function. Its purpose was to select one or more elements from a specified object and return them. In the R language, this function can select rows and columns of data from a matrix, a list, or a data frame. For example: - As for the selection of the elements of the matrix: create a matrix `a <- c(1,2,3,4)`. If `a(2)` is used, the second element 2 will be returned. If `a(c(1,3,4))` is used, the first, third, and fourth elements will be returned. - For the selection of matrix elements: create a matrix `b <- matrix(c(1,2,3,4,5,6),nrow = 2, ncor = 3)`, use `b(1,2)` to return element 2 in the first row and second column, use `b(,3)` to return all elements in the third column. - For the selection of data frame elements: create a data frame `c <- data.frame(name = c("John","Mike","Lily"),age = c(20,25,30))`, use `c(2,1)` to return the element Mike in the first column of the second row, use `c(,2)` to return all the elements in the second column (age column), use `c$name` to return all the elements in the name column. "Choose" was equally exciting. Everyone was welcome to read it!
The use and function of gardenia
Gardenias have many uses and effects: - ** Medicinal **: - It has the effects of clearing heat, diuretics, cooling blood, detoxifying, lowering blood pressure, relieving cough, relaxing bowels, and preventing cancer. - It tastes bitter and cold. It can clear the lungs and cough, cool blood and stop bleeding. It can be used to treat cough due to lung heat and epistax. - Modern pharmacology research showed that it had an suppressive effect on the yellow fungus of Xu Lan and the red skin fungus. It could be used together with chrysanthemum, gentian, scutellaria, etc. to treat red eyes and swelling pain. - It has certain antiseptic and anti-inflammatory effects, and can be used to treat skin infection and oral ulcers. - It could clear away heat and detoxify, and was used to treat fever, oral sores, carbuncle, and other diseases; it could soothe the liver and gallbladder, promote bile secretion and secretion, and prevent diseases such as gallstones; it could promote blood circulation and remove blood stasis, and could be used to treat diseases such as blood stasis and blood stasis. It was a good medicine for bruises and injuries; it could also be used to maintain beauty, and could be used to lighten skin, detoxify and maintain beauty, and delay aging. However, gardenia is toxic and should be used with caution. It is recommended to use it under the guidance of a doctor. - Due to its cold nature, people with weak spleen and stomach should use it with caution to avoid diarrhea symptoms. - ** Ornamental **: Has ornamental value. - ** Plant maintenance **: gardenia is a typical acid loving plant. During maintenance, dilute a spoonful of FeSO4 with water every 7 days and irrigate the soil. It can maintain the acidic soil and help it grow. It can avoid yellow leaves and falling leaves. It is also suitable for acid loving plants such as camelia, boughs, hydrangea, and roses. - ** Dyeing **: The flowers, leaves, and fruits of gardenia can be used for dyeing. The dyeing effect of the fruit is better. When the fruit of gardenia blooms and turns orange, it can be picked and dried and stored. It can be specially used for dyeing. Gardenia-yellow dyed cloth is bright yellow, and after oxidization, it becomes orange. Its fruit is also commonly used for food dyeing. For example, golden chicken may have been cooked with gardenia-yellow. - ** Flower Cultivation **: If the gardenia that you just bought home is shoveled, you can remove the flower bud to save nutrients and put it in a pot. Do not apply fertilizer when it is slowly growing. Put it in a cool place that emits light to avoid exposure to the sun. When the yellow leaves begin to sprout, you can change the pot.(You can also choose not to change the pot, but you have to put a tray below it); If you want to make it bloom when changing the pot, you can add sheep dung and bone powder when mixing the soil; gardenia is a tropical plant, so it is best to change the pot in summer; it can bloom twice a year, mainly in May to June, and a small amount of flowers will bloom in August to September; trimming should be done in July and August; Flower buds begin to grow in February. In areas outside Guangdong and Guangxi, if it is trimmed in autumn, it may not bloom in summer if it does not grow in winter. Below 0 degrees, it was easy to freeze to death and frostbite. In winter, cold protection measures should be taken in the open air. When planting nutritious soil, the soil should be stuffed tightly to preserve water. After changing the basin, put it in a half-shady place for a few days before sunbathing. The novel "Smelling the Jasmine Fragrance Again" is equally exciting. Everyone is welcome to click and read it!
How to choose names to use in a story?
You can choose names based on the character's personality. For example, if it's a brave character, a strong - sounding name like 'Max' or 'Aria' could be suitable. Also, consider the story's setting. A name like 'Luna' might be great for a fantasy story set in a magical land.
How to use the listening function?
Listening to books was an online reading method that allowed users to read books through their hearing without their eyes. To use the book listening function, you need to first choose a book listening platform such as Netease Cloud Music, Himalayan PM, etc. Then, he needed to register an account and log in to the platform. After logging in, he chose the book he wanted to listen to and clicked the "Start Listening" button. Next, the listening platform would convert the text content of the book into voice and play the corresponding voice content. The user can hear the book's text and the sound of the book being read aloud, so they can do other things while listening to the book. It should be noted that the listening function may not support all books. Some books need to be read in other ways. In addition, the listening function may be affected by the network condition. If the network is not good, it may affect the listening effect.