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.
SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 1
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:
SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 2
- In the cell to calculate enter the formula : = SHEET (C6)
SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 3
- Press Enter -> return value is:
SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 4
- Similarly copying the formula for the remaining values results:
SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 5
- You can enter the worksheet name directly in the function:
SHEET function - The function returns the worksheet number value of the referenced worksheet in Excel Picture 6
Above are instructions and some specific examples when using SHEET function in Excel.
Good luck!
You should read it
- Round function, how to use rounded functions in Excel
- What is a worksheet? Differentiate between Worksheet and Workbook
- 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
- The DAYS function - The function returns the number of days between 2 dates in Excel
- GAMMA function - The function returns the gamma function value in Excel
May be interested
SHEETS function - The function returns the number of pages in a reference in Excel
TYPE function - Function that returns the data type of any value in Excel
NA function - The function returns the # N / A error value in Excel
Guide to familiarize yourself with Excel
How to create the first Workbook in Excel
How to use functions to identify and calculate date information in Excel