Dow Jones Up or Down For the Day

[Randy]

I'm trying to show the opening for the day in one column the closing in the
next column and then the number Up/Down in the next column and have it
represented as a negative (down) or positive (up) for the day.

Thanks,
Randy

 

[Bob Phillips]

Seems too obvious, but

=b1-a1

and format as

#,##0.00;-#,##0.00

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[RagDyeR]

With Opening in Column A, and closing in Column B, in C1 enter:

=B1-A1

And copy down as needed.

You then could format Column D to Wingdings, and enter this in D1:

=IF(C1>0,CHAR(241),IF(C1<0,CHAR(242),CHAR(243)))

And copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I'm trying to show the opening for the day in one column the closing in the
next column and then the number Up/Down in the next column and have it
represented as a negative (down) or positive (up) for the day.

Thanks,
Randy

 

[Randy]

Thanks Bob - I came up with the same thing after I had enough coffee and
could think clearly......Thanks for your help!

Randy

 

[Randy]

Perfect!!!!
Thanks!

 

[RagDyer]

You're welcome, and appreciate the feed-back.