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
On Thu, Jun 18, 2009 at 10:07 AM, Mahesh <mahender.bi...@gmail.com> wrote:
> 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
>>
>>
>>
>>
>> On Fri, Jun 5, 2009 at 9:11 PM, Ayush <jainayus...@gmail.com> wrote:
>>
>>>
>>> Hello Everyone,
>>>
>>> Please submit your tip in this post for Week # 24. I am looking for
>>> your overwhelming response in this competition.You just need to submit
>>> your name along with the tip and subject. The tip can be shortcut,
>>> trick, hidden secret, etc.
>>>
>>> Last Submission Date -----13th June 2009.
>>> Winner Declaration Date -----14th June 2009.
>>>
>>> Example :
>>>
>>> Name : Ayush Jain
>>> Subject : the Great 'F4'
>>> Tip : The 'F4' is easily the most useful shortcut key in Excel.
>>> Basically it repeats your last command.
>>> So say you changed the color of a font in a cell. Now click in a new
>>> cell and hit 'F4' and it will change the font in the new cell to the
>>> same color.Wonderful, right? Well what's great about this is that it
>>> works for nearly everything else in Excel too.Highlight a row, right-
>>> click and choose 'Delete'. Now highlight another row and hit 'F4'. It
>>> deletes that row.Whatever you did last, Excel will attempt to repeat
>>> the same command until you do something else. This works great for
>>> things that require you to go to the menus or right-click and make
>>> choices or click buttons that bring up more dialogs. It can be huge
>>> time saver once you get used to using it. As the help says, it doesn't
>>> work in every situation but most times 'F4' works great.
>>>
>>>
>>> SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP & WIN PRIZES. Invite
>>> your friends too for participation in the contest. The more
>>> participation means more learning.
>>>
>>> Thanks again,
>>> Ayush Jain
>>>
>>> --
>>> Thanks & Regards,
>>>
>>> Harmeet Singh
>>>
>>>
>>>
>
>
> --
> 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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
