/-/S'pht-Translator-Active/-/


Re: newbee spreadsheet question (OT)
Posted By: YossarianDate: 5/23/05 4:17 p.m.

In Response To: newbee spreadsheet question (OT) (•M)

: Uhm, how do I do that (in a spreadsheet)?
: mac osx | appleworks 6 | mesa3 : all should do excel-style

Well, all I can attest to is Excel. Next to each cell, do the formula =A1*.25 where A1 is the cell with the value to be multiplied. If all your values are in one column, simply copy the formula and paste down to the bottom of your list. Now you have to convert the formulas to values. Highlight all of your formula cells, right-click and "Copy", right-click again and "Paste Special". Click the "Values" checkbox and then OK. The formulas are changed to numbers. Cut these and paste them over the original values and that's it.

If you can't get it right, send it to me in CSV format and I'll see if I can do it...

-Y

[ Post a Reply | Message Index | Read Prev Msg | Read Next Msg ]
Pre-2004 Posts

Replies:

newbee spreadsheet question (OT)•M 5/23/05 2:16 p.m.
     Re: newbee spreadsheet question (OT)Yossarian 5/23/05 4:17 p.m.
           Re: newbee spreadsheet question (OT)Reiginko 5/24/05 3:50 a.m.
           Re: newbee spreadsheet question (solved)•M 5/24/05 3:55 a.m.
                 Re: newbee spreadsheet question (solved)Yossarian 5/24/05 4:08 a.m.

[ Post a Reply | Message Index | Read Prev Msg | Read Next Msg ]
Pre-2004 Posts

 

 

Your Name:
Your E-Mail Address:
Subject:
Message:

If you'd like to include a link to another page with your message,
please provide both the URL address and the title of the page:

Optional Link URL:
Optional Link Title:

If necessary, enter your password below:

Password:
 

 

Problems? Suggestions? Comments? Email maintainer@bungie.org

Marathon's Story Forum is maintained with WebBBS 5.12.