help with "=(A3*A3)" command

  • Thread starter Thread starter happee
  • Start date Start date
H

happee

Hello,

Does anyone know why a function i used to use like:
=A3*A3

doesn't work anymore. Like say the value in cell A3 was 2, and in cel
B3 i type: =A3*A3

the result in cell B3 would normally be 4, but now when i try to d
something like that it says: #VALUE!

I even tried changing the formula around like =(A3*A3)

well, can anyone help me out? It doesn't even work if i try to use i
for subtraction or division..even if i try to use different cells lik
=C3-C4 or something.

HELP ME!!!!!
 
Hi
probably cell A3 is not stored as number but as 'Text'. I would assume
the following formula returns FALSE:
=ISNUMBER(A3)

check cell A3. You may try:
=(--A3)*(--A3)
 
Happee,

Something is wrong with what's in A3. Try selecting it, then moving the
cursor left and right with the arrow keys. Do you see more than just the
one character, 2 ? What does =LEN(A3) yield?
 
I agree that A3 must not be numeric, but if it could be coerced to a
number then =A3*A3 would be sufficient to coerce it.

Jerry
 
Back
Top