While working with Excel, you may have noticed that sometimes the letter E appears in the calculation. In some cases, after the letter E there was a positive number, and sometimes a negative one. This is called the scientific notation.Excel uses this notation to display a result in a shorter form, otherwise, it would have to display only part of a number as it does with text. Definition of excel in the Definitions.net dictionary. Meaning of excel. What does excel mean? Information and translations of excel in the most comprehensive dictionary definitions resource on the web.
QUESTION
Erika saw an Excel formula that started with: =+
What's the deal?
ANSWER
Nothing.
People who grew up with Lotus notes got into the habit of starting a formula with ‘+' and they carried it over to Excel.
What excel does with that is simply add ‘=' to the front and you end up with formulae that can look like:
=+INTERCEPT(C6:C10,B6:B10)
What excel does with that is simply add ‘=' to the front and you end up with formulae that can look like:
=+INTERCEPT(C6:C10,B6:B10)
What Does Excel Mean In Wikipedia
This is drastically different from seeing a double-minus (technically called ‘double unary') in a formula. The double-unary returns 1 or 0 instead of ‘TRUE' or ‘FALSE.'
An Excel formula that starts with =+ is nothing. It's an old habit that Lotus Notes users have for starting a formula.
Erika, there's nothing to worry about. Whether a formula starts with = or =+ the answer is going to be the same. Just keep on movin' and keep your data clean!
What Does Excel Mean Dictionary
photo credit: Helga Weber via photopincc
