How to know what function formula is used in the attendance table?
The following are some common formulas used for attendance tables: 1. * * Calculating the employee's working hours on the day **: Enter the formula = B2-A2 in cell C2 to get the employee's working hours on the day (if you need to deduct the lunch break, you can do it separately). 2. * * Judge whether an employee is late **: Assuming that the employee is late if he or she punches in after 08:30 in the morning, enter the formula = IF (A2-"08:30"> 0,"Late","") in cell C2. 3. * * Judge whether the employee leaves early **: Assuming that leaving before 17:30 pm is considered leaving early, enter the formula = IF (B2-"17:30"<0,"Leave early","") in cell C2. 4. * * Calculating the number of days of attendance of the employee in the month **: Assuming that the employee goes to work normally, mark a tick under the date. You can use the formula J4 = CountiF (C4: I4,"tick "). 5. * * Identification of card swiping or fingerprint card punching situation (one person punching multiple times or missing punching)**: Create a label auxiliary column in column C, enter the formula = IF (B2 = Min (IF (A$2: A$6 = A2,B$2: B$6)),"Work", IF (B2 = Max (IF (A$2: A$6 = A2,B$2: B$6)),"Work","")) in cell C2, press and hold down Control + Shift with your left hand, press Enter with your right hand to run the formula and fill it down. 6. * * Setting the date of the attendance sheet (take the Date function as an example)**: The formula here is "= Date (C3, E3, 1)". The Date function has three parameters in parenthesis. The first is the year (range 1904 - 9999), the second is the month (range 1 - 12), and the third is the day (range 1 - 31). The second day was set to the previous date +1, and then dragged back to fill in. If you want the number of days in a month to be displayed according to the actual number of days, and the extra column after the month with less than 31 days is displayed as empty, you can use the Mongth function and the IF judgment function, such as "= IF (Mongth (AD 4)= Mongth (AD 4 + 1), AD 4 + 1,"")". You can also improve the formula or use the IFEND function to avoid reporting errors. 7. * * Note: Clock-in time (according to different working hours)**: For example, if the time is divided into morning work, morning off work, afternoon work, and afternoon off work, the formula of E2 cell is: = IF (D2 <=$K$1,$K$2,"")& IF (AND (D2>=$L $. Read more exciting novels for free
How to lock the data in the attendance table formula
To lock the formula in the dynamic attendance sheet, you can do the following: 1. Open the table, select the cell area containing the formula, click the right mouse button and select " Set Cell format ";; 2. In the pop-up window, he clicked on the " Protect " tab and checked the " Lock " option. 3. He clicked on the " Review-Protect Work Form " on the menu bar. A window popped up and he entered the password and clicked OK. After this setting, clicking on the cell containing the formula would cause an error notification to pop up, thereby achieving the purpose of locking the formula. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
60 years table formula
On the 18th, there was gold in the sea, and on the 18th, there was a fire in the furnace. On the 15th, there were large trees, and on the 16th, there was soil beside the road. On the 18th, the sword edge was gold, and on the 18th, a fire broke out on the top of the mountain. Bingzi Dingchou stream into the water, Wuyin Jimao wall soil. On the 18th, white wax gold was used, and on the 18th, willow wood was used. On the 18th, there was water in the spring, and on the 18th, there was earth on the house. On the 15th, there was a thunderbolt and fire, and on the 16th, there was a pine and cypress tree. Imjin, Gui Si long water, Jiawu, Yi Wei sand gold. A fire broke out at the foot of Dingyou Mountain on the 18th, and trees were planted on the ground on the 18th. On the 17th, the wall was covered with earth, and on the 18th, the gold was covered with gold. Jiachen Yisi Buddha lights, Bingwu Ding Wei Tianhe water. On the 15th, the post station was built, and on the 15th, the ring gold was inserted. Renzi Guichou mulberry branches, Jiayin Yimao big stream. On the 18th, the sand in the middle of the earth was scattered, and on the 18th, there was a fire in the sky. On the 18th, the pomegranate tree was planted, and on the 18th, the sea was flooded. " Shen Mingri " is equally exciting. Everyone is welcome to click and read it!
Function that the company attendance sheet will use
The following functions may be used in the company's attendance sheet: 1. **Date function **: Can be used to set dates, such as when calculating the date in the attendance sheet, obtaining the dynamic year and month, or combining the year, month, and day information. For example, when calculating the number of days in the month, you can use the END function to get the date of the first day of the first month of the next month, and then perform the relevant calculations to get the total number of days in the month. 2. ** WUEKDY function **: It is used to change the date to the number represented by the week. The parameters can be set according to the requirements, so that the Monday is displayed as "1". For example, it could be used to make the date in the attendance sheet automatically display the corresponding week. 3. **IF function **: It can perform a condition judgment and return the corresponding value according to the judgment result. For example, to determine whether an employee is late or early, if the employee punches in after 08:30 in the morning, it will be considered late. The formula is C2 = IF(A2 - "08:30" > 0, "late", ""). If the employee punches in before 17:30 in the evening, it will be considered early. C2 = IF(B2 - "17:30" < 0, "early leave", ""). It can also be used to determine whether the week number displayed is 7. If it is, it will be converted to "day". 4. **Countif function **: It can be used to calculate the number of days an employee is on duty in the month. For example, the formula J4 = Countif(C4:I4, "tick") is used to calculate the number of qualified employees in a specific area (if marked with a tick, it means that they are on duty). 5. **Min function and Max function **: When dealing with the situation where an employee punches in multiple times, if the data is in the format of two columns, namely name and each time of punching in, then Min(IF(A$2:A$6 = A2,B$2:B$6)) can return the minimum value of Zhang San's punching in that day, and Max(IF(A$2:A$6 = A2,B$2:B$6)) can return the maximum value of punching in that day. The function that is embedded outside the function can determine whether to punch in or punch out according to the minimum value of punching in. 6. ** Months **: Can be used to judge the date of the month. For example, when dealing with the date display in the attendance sheet, the Months function may be used on the 29th and the IF judgment function may be embedded to make relevant settings according to the different months to make the date display in the attendance sheet more reasonable (for example, to deal with the situation where the number of days in February is less than 31 days). <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
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!
corresponding function formula
I'm not sure what the corresponding function formula you mentioned is about. Is it a specific mathematical problem, data processing requirements, or something else? Please provide more detailed information so that I can answer accurately. " Choose " was equally exciting. Everyone was welcome to read it!
How to copy the formula content data in the dynamic attendance form?
The reference materials did not mention the relevant content of the dynamic attendance table to completely copy the formula content data. Sorry, according to the information retrieved, I don't know how to answer. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Derivative Formula of Inverse Function of Sine Function
设\(y = \arcsin x\)，则\(x = \sin y\)，对\(x = \sin y\)求导得\(x^\prime=\cos y\)，根据反函数导数公式\(y^\prime = \frac{1}{x^\prime}\)，所以\((\arcsin x)^\prime=\frac{1}{\cos y}\)。又因为\(\cos y = \sqrt{1 - \sin^{2}y}\)，而\(x = \sin y\)，所以\(\cos y=\sqrt{1 - x^{2}}\)，那么\((\arcsin x)^\prime=\frac{1}{\sqrt{1 - x^{2}}}\)。 <a href="/?from=ask_words" style="color:red" target="_blank">点击前往免费阅读更多精彩小说</a>
Chinese dynasties table pithy formula
There were many versions of the mnemonic formulas for the past dynasties in China. For example," The Three Emperors and Five Emperors began with Yao, Shun, and Yu. The Xia, Shang, and Western Zhou dynasties were divided into two parts. The Spring and Autumn Period and the Warring States Period unified the Qin and Han Dynasties. The Wei, Shu, and Wu dynasties were divided into three parts. The Jin and Jin Dynasties extended. The Northern and Southern Dynasties were unified. The Sui, Tang, and Five Dynasties were passed down. After the Song, Yuan, Ming, and Qing Dynasties, the dynasty ended." "The Three Sovereigns and Five Emperors, Xia, Shang, and Zhou, and the Spring and Autumn Warring States Period were in chaos. Qin, Han, Three Kingdoms, Eastern and Western Jin, Southern and Northern Dynasties were rivals. The Sui, Tang, Five Dynasties, and Ten Kingdoms, the Song, Yuan, Ming, and Qing Dynasties, and the emperors were all dead." Wait a minute. These chants could help people remember the order of China dynasties.
Heavenly Doctor Combination Formula Table
Formula of Hm steel weight table
The weight calculation formula of the HM-type steel was calculated by multiplying the cross-section area of the steel by the length and then the density of the steel, which was weight = cross-section area x length x density. Among them, the cross-section area of the HM-shaped steel could be calculated by measuring its width, height, and thickness. The length referred to the length of the steel, and the density referred to the density of the HM-shaped steel, which was generally 7.85 g/cm. The formula weight (kg/m)=0.00785 x cross-section area (mm squared) can also be used to calculate its weight per meter. The novel "Watching the Moon on Fish Island" is equally exciting. Everyone is welcome to click and read it!