View original (French)

=+B1/A1 why the "+" ?

Solved
Licorne rose Posted messages 1047 Status Member -  
Miura564 Posted messages 14829 Registration date   Status Member 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 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor 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
  2. Licorne rose Posted messages 1047 Status Member 226
     
    Thank you Eric,

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

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

      the + is useless, it’s just that the person who typed the formula did it in uppercase.
      0
  3. Licorne rose Posted messages 1047 Status Member 226
     
    Thank you both.

    How come Excel doesn't flag an error when reading this strange formula?
    -1
    1. Miura564 Posted messages 14829 Registration date   Status Member 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