View original (French)

=+B1/A1 why the "+" ?

Solved
Licorne rose Posted messages 1047 Status Membre -  
Miura564 Posted messages 14829 Registration date   Status Membre Last intervention   -
Hello,

In an Excel file created by someone else, I see the calculation
=+B1/A1
What is the purpose of the +?
If I write
=B1/A1
I get the same result.

Thank you,

L

Configuration: Laptop W8
Firefox
Office 365 (2013)

3 réponses

Réponse 1 / 3
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Hello,

you found it, it’s useless here.
eric

--
By trying continuously, one eventually succeeds.
So the more it fails, the more chances we have that it will work. (the Shadoks)
In addition to the thank you (yes, it’s done!!!), remember to mark it as resolved. Thank you
0
Réponse 2 / 3
Licorne rose Posted messages 1047 Status Membre 227
 
Thank you Eric,

In what cases can the + be useful (besides thing + thing obviously...) ?

LR
0
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
to nothing but the bill it seems to me
eric
0
Miura564 Posted messages 14829 Registration date   Status Membre Last intervention   1 560
 
Hi,

the + is useless, it’s just that the person who typed the formula did it in uppercase.
0
Réponse 3 / 3
Licorne rose Posted messages 1047 Status Membre 227
 
Thank you both.

How come Excel doesn't flag an error when reading this strange formula?
-1
Miura564 Posted messages 14829 Registration date   Status Membre Last intervention   1 560
 
because it is not an error... for a positive number you can or cannot include the sign + in front while a negative number necessarily has the sign -

+B1/A1 is equivalent to B1/A1
-B1/A1 is different from B1/A1
0