help with "=(A3*A3)" command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

happee - 16 Oct 2004 21:01 GMT

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

Reply to this Message

Frank Kabel - 16 Oct 2004 21:21 GMT

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)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> 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

cell

> B3 i type: =A3*A3
>
[quoted text clipped - 4 lines]
>
> well, can anyone help me out? It doesn't even work if i try to use

> for subtraction or division..even if i try to use different cells

> =C3-C4 or something.
>
[quoted text clipped - 5 lines]
> happee's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15369
> View this thread: http://www.excelforum.com/showthread.php?threadid=269873

Reply to this Message

Jerry W. Lewis - 17 Oct 2004 13:29 GMT

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

> Hi
> probably cell A3 is not stored as number but as 'Text'. I would assume
[quoted text clipped - 50 lines]
>>
> http://www.excelforum.com/showthread.php?threadid=269873

Reply to this Message

Earl Kiosterud - 16 Oct 2004 21:58 GMT

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?

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> Hello,
>
[quoted text clipped - 14 lines]
>
> HELP ME!!!!!!

Reply to this Message