Why inclusion of paranthesis change the result in excel 2007

Discussion in 'Microsoft Office' started by jraju, Nov 7, 2013.

  1. jraju

    jraju MDL Member

    Apr 6, 2013
    154
    7
    10
    #1 jraju, Nov 7, 2013
    when i type =1-.78-.22, I get 0 but when i enter =(1-.78-.22), i get error result -2.77556E-17. If i ask the expert, it was told that this is due to some hidden errors while deducting. Will this error would not modify the result of calculation if it is in the centre of a multiple formula.
    This error, i think, was not found in the ms office 2003. Was there any correction by the microsoft in this regard. pl
     
  2. Mr Jinje

    Mr Jinje MDL Expert

    Aug 19, 2009
    1,769
    1,106
    60
    #2 Mr Jinje, Nov 7, 2013
    Same exact thing occurs in 2003 excel with that formula.
     
  3. cmos

    cmos MDL Junior Member

    Sep 29, 2009
    67
    49
    0
    #3 cmos, Nov 7, 2013
    well, if you "Format Cells ..." to "Number" the error is gone,( or i believe so ?!)
    see the attach.
    Untitledexcel03.png
    cmos
     
  4. jraju

    jraju MDL Member

    Apr 6, 2013
    154
    7
    10
    #4 jraju, Nov 7, 2013 (OP)
    Ok.cmos you are correct, but normally when you place =sign, the excel takes anything as formula, and formula is obviously with numbers only. Why you have to format it to get this. So , should it mean that you have to format all the cells before entering formula