Newbie - Unable to do Simple Formula(s)

Newbie - Unable to do Simple Formula(s) - #value error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

captainkwe - 04 Sep 2004 02:57 GMT

Hello,
Many thanks in advance! I know very little about Excel....but here i
what I thought was a simple exercise:

I wanted to sell some stock. Since the stock isn't doing too well righ
now, I wanted to compare what I paid for it (ESPP) in the past with ho
it is doing today - then figure out if I'd be losing money (and ho
much). Since the values fluctuate over time (Stock price), I though
"Hmm...what a good way to learn Excel" :)

Essentially, all I am trying to do is figure out my loss if I were t
sell today, at $84.39. When trying to subtract an amount from today'
price, I keep getting #value error. I've tried formatting th
appropriate cells to a common format (currency) - thinking all thi
cutting and pasting might have something hidden...but to no avail
Hopefully, the example enclosed will explain.

Many thanks for any assistance

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=68481
--
Message posted from http://www.ExcelForum.com

Reply to this Message

Biff - 04 Sep 2004 05:52 GMT

Hi!

You were right about the cutting/pasting and having hidden
junk embeded in the cells. The values in col D are *text*
and are not numeric numbers. Also, those asterisks in some
of the cells don't help matters! :D

Here's a quick solution. In col M change the formula to:

=G3-MID(D3,2,5)

and just copy down.

Biff

>-----Original Message-----
>Hello,
>Many thanks in advance! I know very little about

Excel....but here is

>what I thought was a simple exercise:
>
>I wanted to sell some stock. Since the stock isn't doing

too well right

>now, I wanted to compare what I paid for it (ESPP) in the

past with how

>it is doing today - then figure out if I'd be losing

money (and how

>much). Since the values fluctuate over time (Stock

price), I thought

>"Hmm...what a good way to learn Excel" :)
>
>Essentially, all I am trying to do is figure out my loss

if I were to

>sell today, at $84.39. When trying to subtract an amount

from today's

>price, I keep getting #value error. I've tried formatting

the

>appropriate cells to a common format (currency) -

thinking all this

>cutting and pasting might have something hidden...but to

no avail.

>Hopefully, the example enclosed will explain.
>
>Many thanks for any assistance.
>
> Attachment filename:

example.xls

>Download attachment: http://www.excelforum.com/attachment.php?postid=684816
>---
>Message posted from http://www.ExcelForum.com/
>
>.

Reply to this Message

captainkwe - 04 Sep 2004 16:23 GMT

Many Thanks Biff

--
Message posted from http://www.ExcelForum.com

Reply to this Message