Why put "+" in front of a formula

F

fzhou

Board Regular
Joined
Nov 6, 2003
Messages
133
Hello everyone,

I have seen many formulae with "+" in the front, could anyone explain to me why? Sometime I also see "+0" in the end, meaning force the result to be a number?

Thanks in advance.

Frank
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
see it does not highlight anything its just signs the positive signs and when u want to start with a formula and in hurry u can use either
+ and - sign and later on when u have finished the formula they apper after "=" sign....

Saurabh
 
Upvote 0
2 reasons. First ,it is a carry over from Lotus 1-2-3 where you used the + sign rather than the = sign ti indicate a formula. Second, when entering formulas with mostly numbers, you can use the numeric keypad and one hand rather than finding the = sign.
 
Upvote 0
saurabh726 said:
see it does not highlight anything its just signs the positive signs and when u want to start with a formula and in hurry u can use either
+ and - sign and later on when u have finished the formula they apper after "=" sign....

Saurabh
Click to expand...

Yes, but Excel will convert + to =.

Can you give us an example of what you're asking about?
 
Upvote 0
Once again, yes, you can use + to start a formula but I doubt you've seen it in a worksheet because Excel will convert + to = as soon as you hit enter.
 
Upvote 0
Once again, yes, you can use + to start a formula but I doubt you've seen it in a worksheet because Excel will convert + to = as soon as you hit enter.
Click to expand...
Kind of: +1+2, will appear as =1+2, but +A1+2, will appear as =+A1+2.

Smitty
 
Upvote 0
fzhou said:
...Sometime I also see "+0" in the end, meaning force the result to be a number?...
Click to expand...

Yes. It effects coercion from a text-formatted number or logical value to a number (with logical values: TRUE --> 1 and FALSE --> 0).
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Help with formula please, if two values match calculate the difference between 2 dates
2
Replies
11
Views
435
Newbie73
N
H
  • Question Question
Number with Apostrophe in front doesn't know if it is a number or text!
Replies
6
Views
608
RoryA
RoryA
F
  • Solved
Add trailing zeros in VBA
Replies
2
Views
108
Flavien
F
M
  • Question Question
Formula Calculation is Inadvertently Switching from Automatic to Manual...
Replies
0
Views
234
MNexcelguy19
M
A
  • Question Question
INDEX Reference Error
Replies
2
Views
46
AYouQueTai
A

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top