Results 1 to 3 of 3
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    TYPE function (Excel all)

    Hi Guys
    I'm just doing some research on the TYPE function, pretty straightword stuff - but what caught my eye was the following part of the help file.
    "TYPE is most useful when you are using functions that can accept different types of data, such as ARGUMENT and INPUT. Use TYPE to find out what type of data is returned by a function or formula. "
    Now, as far as I know there aren't any functions called ARGUMENT or INPUT.
    Are these mystery excel functions or is this just a poorly worded help file?

    Any thoughts on this?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: TYPE function (Excel all)

    INPUT and ARGUMENT were functions in the ancient macro language used in Excel 4 and earlier. TYPE was intended to be used ion conjunction with them; it survived into later versions of Excel, probably because it might be useful by itself.

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: TYPE function (Excel all)

    And they haven't updated the help file since ! hee hee
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •