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.
at

1 comment:

  1. UnknownDecember 16, 2015 at 6:04 PM

    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

Subscribe to: Post Comments (Atom)

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...

  • Multiple Row Filters in Same Sheet
    I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
  • Tips to look more profession in Excel
    Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
  • Remove Non Printable Items from Text
    To Remove None Printable items from the cell containing text we just have to use a simple formula =Clean(Cell number) For Example In cel...