+ Reply to Thread
Results 1 to 3 of 3

Significance of leading plus sign in formula

  1. #1
    Registered User
    Join Date
    06-05-2009
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    1

    Significance of leading plus sign in formula

    I have a project to develop a VB.NEt calculator to replace an existing EXCEL program,

    I have used EXCEL forever, but never come across the following before:

    I am wondered if there is any significance in teh '+' sign preceeding the equation?

    (its a little hard nailing what to search for in help on this sort of issue)

    '=+D11-0.2'
    '=+D38/D26'
    '=+D39*0.15'

    What concerns me is that they are not using this consistently throughout the excel sheet.

    Coming from a C++ background '=+' has significance

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Significance of leading plus sign in formula

    It is unnecessary and of no significance.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    04-03-2007
    Location
    Auckland, New Zealand
    MS-Off Ver
    2007
    Posts
    137

    Re: Significance of leading plus sign in formula

    Hi,
    My memory is a little vague on this but I think the leading '+' is a hangover from the old Lotus days where you could beginning entering a formula with + instead of =.
    Some accountants I know still use this method in Excel.
    (It's quicker when just using the numeric keypad)

    As the previous post said, it has no sginificance, it's just a slightly aged way of entering formulae.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1