Formula doesn't work in one computer but in other works

**fjbcmra** · 2013-03-20, 07:24 PM

Hello:
Im trying to use this simple formula =A1-B1 but the result is value. The cells are in general and another complicated formulas do work. In order to complete my job I gotta go to another computer and create the formula if I need to do a subtraction (-). I fixed the Whole office and I also uninstalled the office but still doesn't work.

**NBVC** · 2013-03-20, 07:38 PM

If you enter these formulas in 2 separate cells, =Len(A1) and =Len(B1) do they result in the number of characters you see in A1 and B1?

**fjbcmra** · 2013-03-20, 08:25 PM

Yes..

**NBVC** · 2013-03-20, 09:21 PM

I think then we would need to see a sample workbook showing the problem.....

**fjbcmra** · 2013-03-20, 09:36 PM

The thing is that if I send you the workbook, in your computer gonna work but not in mine. I don't know whats happening with that type of formula.

**NBVC** · 2013-03-20, 09:45 PM

It's hard to diagnose without seeing it, if you say all the other formulas are working. If they are, I'd say that somehow A1 or B1 has a hidden character or text which would cause the #VALUE! error to occur.

**fjbcmra** · 2013-03-20, 09:53 PM

Ok. Here is the file. Let me tell you another thing, no matter which cell I use, or worksheet or workbook, it always give me the same error. I think is an Excel problem but I don't know. I just can subtract this way.

**NBVC** · 2013-03-20, 09:55 PM

When I open the book, I see in C1, =A1,B1 and I see the #VALUE! error. It should be in C1, =A1-B1. When I change it I see a result of 1.

The same is seen in I7.