[sllug-members]: RE: sllug-members Digest, Vol 41, Issue 30

[Jason Edwards]

Okay, is it more like this?:

A1 | 280
A5 | 260
A6 | 270
A7 | 260

B1 | =A1-A5 #=> 20
B2 | =A1-A6 #=> 10
B3 | =A1-A7 #=> 20

C1 | =SUM(B1:B3) #=> 50

Jason

On Jan 18, 2008 5:56 AM, tony wilson <bikergoth at hotmail.com> wrote:
>
> hey Jason,
> thats close, but  B1:B3 would be input subtracted from  A1 with the total updated in C1.
>
> A       B       C
> 285             20
>         275
>         265
>
> if that makes sense
>
> > Message: 7
> > Date: Thu, 17 Jan 2008 14:10:34 -0700
> > From: "Jason Edwards"
> > Subject: Re: [sllug-members]: new guy and help needed
> > To: "Salt Lake Linux Users Group Discussions"
> >
> > Message-ID:
> >
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Hi Tony,
> >
> > Welcome to Utah.
> >
> > I'm not sure if this is what you're looking for, but I made a little
> > spreadsheet, and this is what it contains:
> >
> > A1 | 280
> > A5 | 260
> > A6 | 270
> > A7 | 260
> >
> > B1 | =A5-A1 #=> -20
> > B2 | =A6-A1 #=> -10
> > B3 | =A7-A1 #=> -20
> >
> > C1 | =SUM(B1:B2) #=> -30
> >
> > Is that what you were looking for?
> >
> > Jason
> >
> > On Jan 17, 2008 1:23 PM, tony wilson  wrote:
> >>
> >>  hi there,
> >>  im new to the area, just moved out here from NC in aug. I was somewhat
> >> active with LUG there and hope to get active here.
> >> anyway, im working on an OO.o calc issue that giving me fit (actually, ive
> >> enjoyed the challenge, untill now), im trying to work out a formula that
> >> would allow a subtratction total to be added as input and keep a running
> >> total:
> >>  A1=280
> >>               B1=(X)-A1
> >>               B2=(Y)-A1
> >>               B3=(Z)-A1
> >>                                    C1=SUM((output of:)B1:B2)
> >> X=260
> >>  Y=270
> >>  Z=260
> >>
> >>  out put of C1 hopefully would be 50
> >>  any ideas would be appreciated.
> >>
> >>  tony
> >>
> >> ________________________________
> >> Need to know the score, the latest news, or you need your Hotmail(R)-get your
> >> "fix" Check it out.
> >>
> >> ______________________________________________________________________
> >> See http://www.sllug.org/ for latest SLLUG news, information, links.
> >> Join SLLUG and other UT LUG members on irc.FreeNode.net channel #Utah
> >> sllug-members at sllug.org
> >> http://www.sllug.org/cgi-bin/mailman/listinfo/sllug-members
> >>
> >>
> > -------------- next part --------------
> > A non-text attachment was scrubbed...
> > Name: subtraction.ods
> > Type: application/vnd.oasis.opendocument.spreadsheet
> > Size: 7104 bytes
> > Desc: not available
> > Url : http://sllug.org/pipermail/sllug-members/attachments/20080117/c9595095/subtraction.bin
> >
> > ------------------------------
> >
> > ______________________________________________________________________
> > See http://www.sllug.org/ for latest SLLUG news, information, links.
> > Join SLLUG and other UT LUG members on irc.FreeNode.net channel #Utah
> > sllug-members at sllug.org
> > http://www.sllug.org/cgi-bin/mailman/listinfo/sllug-members
> >
> >
> > End of sllug-members Digest, Vol 41, Issue 30
> > *********************************************
>
> _________________________________________________________________
> Helping your favorite cause is as easy as instant messaging. You IM, we give.
> http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join______________________________________________________________________
> See http://www.sllug.org/ for latest SLLUG news, information, links.
> Join SLLUG and other UT LUG members on irc.FreeNode.net channel #Utah
> sllug-members at sllug.org
> http://www.sllug.org/cgi-bin/mailman/listinfo/sllug-members
>