Hey Mahender,
N() formula is used to hide the text. Its similar to comments in any
other programming languages.
Ex: Lets say i want to find out the area of a rectangle. Then the formula is
a*b.
In cell A1, i write =5*6+N("side1*side2"), the answer you get is 30. But you
cannot see N("side1*side2) in your result. But if you press F2 then you can
see that.
So basically N() formula will help the user to know what the formula is all
about.
I think this helps.
Thank You,
Rajesh
______________________________________________________________________________________________
Hi Harmeet,
Can provide some samples, it will be a gr8 help for us?
Rgds,
Mahender Bisht
On Tue, Jun 9, 2009 at 12:29 AM, Harmeet Singh <harmeet.hew...@gmail.com>
wrote:
HI All,
Name : Harmeet
Subject : Hidden text in Formula
Tip : =2018+1056-4*120+N("My Salary + Bonus - 4 weekly loan repayments")
BY using N() formula You can enter hidden text in your formula.
Try it.............
Regards,
Harmeet
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
