What is purpose of + sign in formula "=+Q290*10"

  • Thread starter Thread starter Sasser
  • Start date Start date
S

Sasser

If I didn't have the + sign in the formula, wouldn't I get the same result?
 
Yes the plus sign is not required... It was probably entered that was as a
matter of convenience. Instead of typing the equal sign they just typed the
plus. XL inserted the equal sign on it's own.
 
It's a "throwback" to Lotus 123 or sometimes used as a shortcut on the
numeric keypad. Ignore or delete.
 
Yes.
The + is usually a relic of someone who previously used Lotus spreadsheets,
which used + where Excel uses =.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What comes after Windows 10? 15
No need to use = sign in formulas 4
Enter sign replace in Excel 2007 2
Working Days function copied down column 1
plus sign before cell reference in formula 1
USE OF THE $ SIGN 4
What does "--" (2 minus signs) do in a formula 1
Count between dates with some entries marked as "-" 5

Back
Top