Perfect!!!!
Thanks!

"RagDyeR" wrote:

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(C10,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!
================================================== ===

"Randy" wrote in message
...
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