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?
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.
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?
Yes..
I think then we would need to see a sample workbook showing the problem.....
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.
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.
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.
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.
that's what I have in the formula let me show u with this print screen
Hmm, I wonder why your sheet would convert to =A1,B1 when I open it.... stumping me....
Bookmarks