Dow Jones Up or Down For the Day

R

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
 
B

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

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
 
R

Randy

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

Randy
 
Top