|
PureBytes Links
Trading Reference Links
|
In your previous mail, you wanted a way to have the formulas being displayed
as well, and as such got the idea that you would like them to be placed in
seperate columns (using the " ' " character or the " ` " character for viewing
the nested formula's purposes).
Since that was not exactly your intension, have printed below a way to have
the formulas being printed in the same cell as well as where the outcomes could
be printed.
=" "&A1+B1&" =A1+B1"
="A2+B2= "&A2+B2
="A3+B3="&A3+B3
The above 3 lines are taken from the Formula Editor Bar and match the "reserve"
sheets' record-rows 1, 2 and 3 as can be seen in the attached GIF
(EXCEL-DisplayFormulas.gif).
It still amazes me how the PaintShopPro5.01 and the HARDCOPY programs can
make such small AND very high quality GIF-files.
After the Alt+PrintScreen keys were pressed down, I could "copy" the Active windows'
contents straight over onto the clipboard, and directly paste cb's contents directly
into a new PSP image file !!!! (only took 1.5 seconds to do), and then only had to
SAVE AS as a GIF-file(256 colors) and 12.5 Kb resulted as the file's size.
(Upose to 89Kb when done the JPEG way!!!)
The lines consists of the following unique parts (1st line as example) :
" " -This is the way text-only can be displayed
(spaces between the quotation marks).
& -This is the AND character used to join(combine)
the inputted parts, and can be text as well as
formulas and or functions.
A1+B1 -The formula to sum Cell A1 plus B1.
" =A1+B1" -The formula, with spaces used for distance, and
is placed between the (for text) quotation marks, as
how it (in this example) needed to be displayed.
The formula as <results> and as <contents> are (then always) displayed in Cell C1.
By the way, refering to your search for indicators, do you have the Excel ValuePack
installed, eg that can be found on the Office CdRom?
It does contains a few indicators (including Exponential etc.).
If not, it can be downloaded from the Microsoft Office Update web-site (for free).
Regards,
Ton Maas
ms-irb@xxxxxx
----- Original Message -----
From: Walter Lake <wlake@xxxxxxxxx>
To: Metastock bulletin board <metastock@xxxxxxxxxxxxx>
Sent: dinsdag 16 maart 1999 13:20
Subject: library of excel code
>Hi Manoj, Cab, Chuck, etc.
>
>Thanks for your idea. "... insert comments in cells for future reference."
>
>I've tried that plus Ton's idea.
>
>Some worksheets have comments for every column. After "lots" of
>worksheets/books, I can't remember where the columns are. <G> That's why I
>collect up the cell-code and email them to myself for "binder" storage /
>reference.
>
>Transfer to "notebook" ends up with weird stuff happening. It must be my
>"magic" touch.
>
>e.g. ... Cab asked me this question.
>
>"... One really basic thing I'd like to figure out is how to do the
>equivalent of Average(Price,Length) where Price would refer to column A,
>B, or whatever, but Length would be a variable, set for example at the
>top of the spreadsheet (i.e., instead of Average(B13:B21). I'm guessing
>that you need to use the Offset, Match, etc. type functions, but haven't
>quite figured it out yet."
>
>I'm still searching through workbooks / sheets to find out if I've ever used
>anything different.
>
>Maybe Chuck has something on his TASC CD of different excel code used for
>moving averages.
>
>Best regards
>
>Walter
>
Attachment Converted: "c:\eudora\attach\EXCEL-DisplayFormulas.gif"
|