thanx a ton........
On Fri, Jun 19, 2009 at 12:45 AM, Harmeet Singh <harmeet.hew...@gmail.com>wrote:
> Thanks Rajesh for quick response.
>
> Mahender, I hope that helps.
>
>
>
>
>
>
> On Thu, Jun 18, 2009 at 11:46 AM, Rajesh Kunder <kunder....@gmail.com>wrote:
>
>> 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
>>
>>
>>
>>
>
>
> --
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
> >
>
--
With Love,
Mahesh Bisht
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
