Excel will not subtract? when I use =SUM(a1:a2) it will ADD the two cells together? this is pc specific and this occurs on all office versions? RRS feed

  • Question

  • I can't understand why *,/,+, all work but the subtract adds the cells together if I use =(A1-A2) I get #VALUE! yet if I change the formula to either add, multipy or divide they work???
    Any ideas?
    Wednesday, August 12, 2009 10:46 AM