Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    + and - signs before cell references in formulas

    What exactly do extra + and - signs mean in before cell references in formulas such as the one that I have posted here (besides regular addition and subtraction). I've seen them before in other formulas, but aren't sure what they mean.

    Here is the scenario:

    At the top of the worksheet are 4 cells: D3 is the Principal Amount, D4 is the Interest Rate, D5 is the Term in Months, and then F4 is the PMT function doing the monthly payment calculation. In the rows below it, the month number is in cell B11, the beginning principal balance is in C11, the Interest Paid is in cell D11, which is what the formula below is calculating.
    =IF(+B11<=$D$5,+C11*($D$4/12),0)
    The monthly payment is being done with =PMT(D4/12,D5,-D3).

    What do the extra + and - symbols mean in both of these formulas?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: + and - signs before cell references in formulas

    Hi,
    Who actually entered the formulae in the first place? As I recall, there are some spreadsheet programs that required a + before a cell reference but Excel does not so they are unnecessary. The - signs simply change the sign of the value in the relevant cell.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: + and - signs before cell references in formulas

    In the cases you gave, it has the same affect as if you put a zero in front of the plus or minus sign. In the case of the plus sign, 0+B11 is the same as B11 and having the plus sign there does nothing. In the case of the minus sign, 0-D3 changes the sign of the value in cell D3 before it is used. If D3 contains a 3, then the value used in the calculation is -3. If D3 contains -3, then the value used in the calculation is +3.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: + and - signs before cell references in formulas

    I too have seen this practice -- primarily used in spreadsheets I've seen built by people in our finance or finance related areas. Is there some convention to adding the redundant (in my opinion) '+'s in front of a number or cell reference?

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: + and - signs before cell references in formulas

    It's a Lotus habit. Annoys me, and I spent 7 years on 123 and Symphony!
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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