Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Robyn K
Robyn K asked in Computers & InternetProgramming & Design · 1 decade ago

what does =+ mean at the beginning of an Excel formula?

2 Answers

Relevance
  • jmorge
    Lv 6
    1 decade ago
    Favorite Answer

    back before Excel (when Lotus 123 was "king"), you started your formula with a "+". So you would enter +A1 to get the value of A1.

    When Excel came out, they changed it to be =A1. But you can still type +A1. When you do it the old way, Excel shows the formula as =+A1.

    Of course you can also do -A1 which would be the negative of A1. And Excel will convert this to =-A1

    bottom line is, it just means it's "adding" the cell reference that follows it.

  • wayfaroutthere
    Lv 7
    1 decade ago

    It's just how you start a formula. I guess you could say that it means 'put the result of everything after this here'.

Still have questions? Get your answers by asking now.