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

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)

"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

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

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

Randy

"Bob Phillips" wrote:

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)

"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

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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Randy" wrote in message
...
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