Tuesday, January 19, 2010

Hidden text in formula

To put hidden tax in formula person have to use N() Function

Example : =100000+50000+N("Party X+Party Y")
Output := 150000


It is helpful when you want to display any information along with formula in single Cell.

1 comment:

  1. Thank you so much for helping me out this. I will recommend this blog readers should also visit http://www.excelrush.com/ , as it also have good number of articles regarding Microsoft Excel.

    ReplyDelete

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...