Negative Column - Is this possible?

  • Thread starter Thread starter DB
  • Start date Start date
D

DB

I'm trying to work something out and I am trying to find out if something is
possible...

Basically I do the losses and gains at work for various stocks - I manually
work out the losses and gains, recording them on a weekly basis.

The format is as follows.......

A B C D
E
Date Loss Gain Net Result this
week Result to Date
1 1/7/07 -50.00
-26.00 - 26.00
2 8/7/07 -100.00 170.00 100.00
74.00
3
4
5
6
7
8
9

Is there a way that can treat the whole B column as Negative, rather than
having to input using a minus (-) sign .

I know it is a tiny problem - but is it possible ?

Many Thanks

DB:)
 
Well, that didnt work out as planned.....I posted it and reviewed
it.............the E column has wrapped around

It should be A to E

Date, 1/7/07 then the loss figure.....then the gain figure......then the net
result for the week.....then the net result for the year so far..


Cheers

DB :)
 
Fri, 06 Jul 2007 18:54:02 GMT from DB <Daveb007
(e-mail address removed)>:
I'm trying to work something out and I am trying to find out if something is
possible...

Basically I do the losses and gains at work for various stocks - I manually
work out the losses and gains, recording them on a weekly basis.
Click to expand...

Please see the answers in the other newsgroup where you posted this.

In future, please don't post the same question twice.
 
In Future Stan..... please be a bit more polite to newcomers........

DB :(

P.S.... Dont bother telling me off about top posting either.......
 
Sun, 08 Jul 2007 11:27:36 GMT from DB <Daveb007
(e-mail address removed)>:
In Future Stan..... please be a bit more polite to newcomers........
Click to expand...

Help me out here. What words would you find acceptable?
 
Back
Top