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


Re: newbee spreadsheet question (solved)
Posted By: •MDate: 5/24/05 3:55 a.m.

In Response To: Re: newbee spreadsheet question (OT) (Yossarian)

: 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.

Works like a charm, thank you kindly!
Seems I must get used to the syntax of it, even managed to use the round-off command (mighty pleased with oneself's l33t mathskillz ;)

[ 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.