[sllug-members]: new guy and help needed

Jason Edwards jtanium at gmail.com
Thu Jan 17 14:10:34 MST 2008


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 <bikergoth at hotmail.com> 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-0001.bin


More information about the sllug-members mailing list