Hi Kuldeep,
T function generally used to check for weather the argument passed in it is
a text or not , If it is a text then it return that text else it return
blank,
For example.
=T("12") will return 12 and if i write the same T(12) will return blank.
Now About N function.
N function is used to converts a value to a number.
- If *value* is a number, the N function returns a number.
- If *value* is a date, the N function returns the date as a serial
number.
- If *value* is TRUE, the N function will return 1.
- If *value* is FALSE, the N function will return 0.
- If *value* is an error, the error value is returned.
- For all other *value*s, the N function will return 0.
for example:
=n(35)=35
=n("hi")=0
Hope this will help you
regards
Prince dubey
On Tuesday, 31 July 2012 21:54:59 UTC+5:30, Kuldeep Singh wrote:
>
>
> Hi Experts,
>
> Kindly tell me about "T", & "N" Formulas with examples. and What is exact
> use for this formulas.
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
