Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11SHEETS function - The function returns the number of pages in a reference in Excel
The following article introduces you to the SHEETS function - one of the functions in the information function group is very popular in Excel.
Description: The function returns the number of pages in a reference. Support functions from Excel 2013 onwards.
Syntax: SHEETS (reference)
Inside:
- reference: A reference to find the page number, is the required parameter.
Attention:
- SHEETS function includes all worksheets, along with all types of macro pages, charts .
- If the reference value is not valid -> the function returns the #REF! Error value
- SHEET function should not be used in the object model because that model already has similar features.
- In case of omitting reference parameter, the function returns the total number of pages in the current working window.
For example:
Calculate the number of pages in a reference described in the table below:
- In the cell to calculate enter the formula : = SHEETS (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- In case of omitting reference parameter -> function returns the total number of sheets of the current working window.
Above are instructions and some specific examples when using SHEETS function in Excel.
Good luck!
Isabella HumphreyYou should read it
- ISREF function - The function returns True if the value is a valid reference value in Excel
- 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
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- The OFFSET function returns a reference in Excel
- ISODD function - The function returns True if the value is an odd number in Excel
May be interested
- POISSON.DIST function - The function returns the Poisson distribution in Excel
poisson.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.
- 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.
- 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.
- Function Address - The function returns the address of a cell in Excel (usage, examples, examples)the following article dexterity software will introduce readers to the address function one of the most popular reference and lookup functions in excel.
- MONTH function - The function returns the monthly value of a day expressed as a serial number in Excelmonth function: the function returns the month of a day expressed as serial number in excel. months are represented by integers with values between 1 and 12 months. syntax: month (serial_number)
- NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excelnetworkdays function: the function returns the number of intact working days calculated between two specific dates. working days do not include weekends and holidays specified. syntax: networkdays (start_date, end_date, [holidays])
- SHEET function - The function returns the worksheet number value of the referenced worksheet in Excelsheet function: the function returns the sheet number of the referenced worksheet. support functions from excel 2013 onwards. syntax: sheet (value)
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Exceldays360 function: the function performs the calculation of the number of days between 2 days, based on 360 days year (from 12 months, 30 days per month). useful function in calculating payments in the accounting system based on twelve months 30 days. syntax: days (start_date, end_date, [m
Office information
- 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
- STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values 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
STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values in Excel