help with "=(A3*A3)" command

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!!!!!
 
F

Frank Kabel

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)
 
E

Earl Kiosterud

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?
 
J

Jerry W. Lewis

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
 
Top