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!
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.
The use and function of lotus flowers
The uses and effects of lotus flowers included the following aspects: First, lotus flowers had the effects of clearing heat and detoxification, dispelling dampness and wind, and could be used to treat symptoms such as heat, polythirst, wet sores and scabies. Secondly, the lotus flower could promote blood circulation and stop bleeding. It had a certain effect on bruises and vomiting blood. In addition, the lotus could also treat a difficult skin disease and had a certain medicinal value. In addition, lotus flowers could also be used for food. Lotus leaves could be used to wrap dishes and increase the taste of food. Lotus tea could clear heat and replenish water. In general, lotus flowers had medicinal and edible value, and were also a beautiful ornamental plant.
The use and function of lotus flowers
The uses and effects of lotus flowers included the following aspects: First, lotus flowers had the effects of clearing heat and detoxification, dispelling dampness and wind, and could be used to treat symptoms such as heat, polythirst, wet sores and scabies. Secondly, the lotus flower could promote blood circulation and stop bleeding. It had a certain effect on bruises and vomiting blood. In addition, the lotus could also treat a difficult skin disease, pemphigus. Lotus could be taken in decoction or mashed and applied to the affected area, which had a certain effect on the treatment of pemphigus. In addition, lotus flowers could also be used to make tea and drink. It had the effect of clearing heat and protecting the heart and blood vessels. In general, lotus flowers had many medicinal values and could be used as medicinal food.
The use and function of lotus flowers
The uses and effects of lotus flowers included the following aspects: First, lotus flowers had the effect of clearing heat and detoxification, and could alleviate symptoms such as heat and thirst. Secondly, the lotus flower could dispel dampness and wind, so it was suitable for treating diseases such as scabies. In addition, the lotus also had the effect of promoting blood circulation and stopping bleeding. It had a certain effect on bruises and vomiting blood. In addition, the lotus flower also had the effect of losing weight. It could break down the body's fat, stimulate the stomach and intestines, and reduce the time it stayed in the stool. The lotus flower could also be used to regulate cardiovascular diseases, alleviate hematemesis, eliminate acne, nourish the heart, calm the nerves, reduce swelling, and so on. In general, lotus flowers had a variety of medicinal value and edible methods. It was a favorite medicinal food.
The use and function of lotus flowers
The uses and effects of lotus flowers included the following aspects: First, lotus flowers had the effects of clearing heat and detoxification, dispelling dampness and wind, and could be used to treat symptoms such as heat, polythirst, wet sores and scabies. Secondly, the lotus flower could promote blood circulation and stop bleeding. It had a certain effect on bruises and vomiting blood. In addition, the lotus could also treat a difficult skin disease, pemphigus. Lotus could be taken in decoction or mashed and applied to the affected area, which had a certain effect on the treatment of pemphigus. In addition, lotus flowers could also be used to make tea and drink. It had the effect of clearing heat and protecting the heart and blood vessels. In general, lotus flowers had many medicinal values and could be used as medicinal food.