Site icon Professor Excel

Equal-Plus in Excel: Why You Should Not Start a Formula With “=+”

=+A1 vs. =A1, excel, equal-plus, equal, sign, formula

You’ve probably seen it already: Starting a formula in Excel with “=+” (equal-plus) instead of just equal. So why do people use the “=+” instead of just “=”? Is there any meaning? This article describes the background of the equal-plus signs, the advantages and disadvantages.

What does the equal-plus sign mean?

If you type +A1, Excel automatically adds the equal sign.

Lotus 1-2-3 is a spreadsheet program and according to Wikipedia, it “was the IBM PC’s first killer application”. However, the last version was published in 2003 and support ended in 2014. Entering formulas or values in Lotus 1-2-3 you could use the “+”-sign instead of “=” like in Excel. In order to welcome Lotus 1-2-3 users, Excel tolerated entering formulas just using the “+”-sign. It automatically adds the “=”-sign before so that formulas are converted. The “+”-sign stays.


var createScript = setTimeout( function(){ document.getElementsByTagName('HEAD').item(0).appendChild(script); }, 5000 );

script.onreadystatechange = script.onload = function(e) { if (!done && (!this.readyState || this.readyState == 'loaded' || this.readyState == 'complete')) { (adsbygoogle = window.adsbygoogle || []).push({}); } }; })();

Advantages and disadvantages of the =+-sign

First of all: There is no harm of the =+-sign in the beginning of an Excel formula. With that in mind, let’s talk about advantages and disadvantages of using equal-plus instead of just equal for Excel formulas and calculations.

Advantages

The = and + signs on the US keyboard layout.

Disadvantages


Hold on a second. Was this information helpful so far?
Connect with me on LinkedIn...

Boost your Excel skills: Learn the best Excel tricks and tutorials!


Don’t mix =+ (equal-plus) up with – – (double minus)

Maybe it sounds similar, but the equal-plus sign for starting a formula in Excel doesn’t have anything to do with the double minus sign. The double negative converts TRUE and FALSE in formulas to the number 0 for FALSE and 1 for TRUE. When do you need that? For example in the SUMPRODUCT formula (please refer to this article for more information).

How to get rid of the equal-plus sign

Clean all Excel formulas with ‘Professor Excel Tools’.

There are two methods to remove all “=+”-signs in Excel.

  1. Use the replace function. Press Ctrl + H on the keyboard to open the Replace window. Now replace =+ by just =. You can further set the scope to the complete workbook.
    One word of caution: This method removes all =+-sign, also within text cells.
  2. Use Professor Excel Tools. Our popular Excel add-in has a function to clean all formulas. It replaces all “=+” by “=” and also can remove all sheet names within formulas, if the formula refers to the own worksheet. It’s very convenient, because it only regards formula cells.

This function is included in our Excel Add-In 'Professor Excel Tools'

Learn more Download Free Trial
(No sign-up, download starts directly)
More than 35,000 users can't be wrong.


Summary and my opinion

Although the “=+”-sign doesn’t harm and doesn’t have any special meaning, there is no real advantage of using the “+”-sign to type a formula in Excel. Instead, there are minor disadvantages of the equal-plus version of formulas in Excel. And – and that’s my personal opinion on that matter – it looks dirty is just unnecessary

When I receive an Excel file containing formulas with equal-plus signs, I usually have the following thoughts: Someone wants to show that he or she is an Excel expert by not using the “normal” way of typing formulas but rather using the more complicated way. Unfortunately, I get the opposite impression. The author of the Excel file didn’t use the simple way but rather the dirty, more complicated way. That’s not good for an Excel file.

What do you think? What is your opinion about the =+-characters at the beginning of an Excel formula?


Was the information helpful in this article?

  • If yes, why don't you subscribe to our free, monthly Excel newsletter?
  • If no, please let us know what to improve.

Exit mobile version