Manuals/calci/N

N(x)

• $x$ is the value.

Description

• This functon gives converted value of a number.
• In $N(x),x$ is the value to convert in to a number.
• The following values are converted in to a number:

X value N returns(Result)

1. A number - The Same number
2. Any date in DATEfunction format- The Serial number of that date
3. TRUE - 1
4. FALSE - 0
5. An error value - Error value
6. Anything else - 0

Examples

1. N(100)=100
2. N(-154)=-154
3. N(2/1/1987)=0.001006543
4. N(TRUE)=1
5. N(FALSE)=0
6. N(2/0)=Infinity
7. N("10/4")=0

See Also

• T

References

Examples

---

'''''''  ''''

---

Description

---

 

This function gives a value converted to a number.

---

N

---

 N(V)

where V   is the value which is to be converted.

---

	Column1	Column2	Column3	Column4
Row1	20	20	word	0
Row2	10/31/2008	Fri Oct 31 00:00:00 UTC+0530 2008
Row3
Row4
Row5
Row6

File:Calci1.gif

---

 

Let's see an example in Column1Row1

Let B2 = 20,

I.e.=N(B2) is 20

Let D2 = word

I.e.=N(D2) is 0

Let B3 = 10/31/2008

I.e.=N(B3) is Fri Oct 31 00:00:00 UTC+0530 2008

---