SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel
The following article introduces you to the SHEET function - one of the functions in the group of information functions that is very popular in Excel.
Description: The function returns the worksheet number of the referenced worksheet. Support functions from Excel 2013 onwards.
Syntax: SHEET (value)
Inside:
- value: The name of a worksheet or reference to find the page number, is a required parameter.
Attention:
- The use of this function should be restricted in formulas because Excel automatically converts as needed.
For example:
Calculate the number of sheets described in the table below:
- In the cell to calculate enter the formula : = SHEET (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- You can enter the worksheet name directly in the function:
Above are instructions and some specific examples when using SHEET function in Excel.
Good luck!
You should read it
- How to rename, copy and move spreadsheets in Excel
- Instructions for copying or moving Worksheet in Excel 2013
- Index function in Excel
- Lock one or more data columns on Excel worksheet - Freeze data in Excel
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- How to move between sheets in a spreadsheet processing program
- RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
- PERMUT function - The function returns the number of permutations of a given number of objects in Excel
May be interested
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excelrank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
- SHEETS function - The function returns the number of pages in a reference in Excelsheets function: the function returns the number of pages in a reference. support functions from excel 2013 onwards. syntax: sheets (reference)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- The SQRT function returns the square root of a positive number in Excelthe sqrt () function in excel helps you quickly calculate the square root of any number you want. the syntax and usage of the function is very simple, but if you do not know, follow the article below.
- How to rename, copy and move spreadsheets in Excelinstructions on how to rename, copy and move spreadsheets in excel. 1. how to change the name of the worksheet (sheet) in excel - method 1: + double-click the worksheet name - when the selected worksheet name is entered, enter the new name of the worksheet: + after entering the name
- How to use ADDRESS function in Excelthe address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.
- POISSON function - The function returns the Poisson distribution in Excelin predicting the number of events that occur within a specific time, one cannot help but use the poisson function. the following article details how to use the poisson function, the function returns the poisson distribution.
- How to display sheet tabs in Excelnormally when working in excel you will see the sheet tabs at the bottom of the interface, showing all the data sheets included in the excel file.