N function - The function returns the numeric value converted from any value other than the error value in Excel
The following article introduces you to the N - 1 function among the functions in the group of information functions that are very popular in Excel.
Description: The function returns a numeric value converted from any value.
Syntax: N (value)
Inside:
- value: The value to convert, is a mandatory parameter including the convertible values as follows:
+ value is a number -> the function returns that number.
+ value is 1 day with the format available in Excel -> function returns the serial number of that day.
+ value = True -> function returns number 1.
+ value = False -> the function returns the number 0.
+ value is an error value like # DIV / 0, #VALUE!, . -> the function returns the error value.
+ value outside the above values -> function returns the number 0.
Attention:
- The use of this function should be restricted in formulas because Excel automatically converts as needed.
For example:
Convert the following values to numbers with the data described in the table below:
- In the cell to calculate enter the formula : = N (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
- Here the logical value is True -> the function returns the value 1.
- Where value is a text value or a blank value -> the function returns the value 0:
- Where value is the #NUM! Error value -> The function returns an error value corresponding to the value in the value:
Above are instructions and some specific examples when using the N function in Excel.
Good luck!
You should read it
- ISNUMBER function - The function returns True if the value is numeric in Excel
- How to use the IF function in Excel
- AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
- How to use the IFS function in Excel 2016
- How to use the SUM function to calculate totals in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- OR function in Excel, how to use the OR function, and examples
- FORECAST function - The function returns a value along a linear trend in Excel
- YEAR - The function for the value is the year of a numeric expression in Excel
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- PHI function - The function returns the value of the density function for a normal distribution in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python