Formula Documentation

%3CLINGO-SUB%20id%3D%22lingo-sub-2027249%22%20slang%3D%22en-US%22%3EFormula%20Documentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027249%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20am%20programming%20in%20any%20assembler%20language%2C%20it%20is%20common%20practice%20to%20embed%20descriptions%20of%20what%20a%20sub-routine%20or%20command%20is%20intended%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20insert%20documentation%20text%20into%20a%20formula%26nbsp%3B%3CEM%3E%3CSTRONG%3Ewithout%20it%20printing%20on%20the%20monitor%20or%20being%20included%20in%26nbsp%3B%3C%2FSTRONG%3E%3C%2FEM%3E%3CSTRONG%3E%3CI%3Ecalculations%3C%2FI%3E%3C%2FSTRONG%3E%26nbsp%3Bwithin%20the%20formula%20itself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CU%3EFor%20example%3C%2FU%3E%3A%3C%2FSTRONG%3E%26nbsp%3B%20This%20is%20a%20formula%20I%20use%20within%20a%20spreadsheet%20to%20help%20me%20make%20specific%20decisions%20using%20discreet%20known%20data.%26nbsp%3B%20The%20first%203%20rows%20are%20column%20headers.%26nbsp%3B%20Cells%20A4%20through%20AS53%20is%20data%2C%20and%20Cells%20AT4%20through%20BI53%20are%20a%20series%20of%20decision%20trees.%26nbsp%3B%20This%20specific%20example%20is%20cell%20AY4.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20though%20I%20wrote%20this%20part%20of%20the%20decision%20tree%2C%20I%20find%20it%20difficult%20to%20remember%20what%20each%20step%20does%20--%20and%20therefore%2C%20it%20is%20difficult%20to%20edit%20or%20modify%20it%20for%20specific%20uses.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(%24A4%3D%22%22%2C%22%22%2CIF(%24AX4%3D%22Pick%22%2C0%2CIF(%24AX4%3D%24A4%2C(((IF(AND(%24E4%3D0%2C%24F4%3D0)%2C1%2C(%24D4%2B(%24F4%2F2))%2F(%24D4%2B%24E4%2B%24F4)))%2B%24L4%2B%24P4%2B%24S4%2B(%24U4%2F10)%2B(%24V4%2F8)%2B(%24X4%2F2))%2F7)%2C(((IF(AND(%24Z4%3D0%2C%24AA4%3D0)%2C1%2C(%24Y4%2B(%24AA4%2F2))%2F(%24Y4%2B%24Z4%2B%24AA4)))%2B%24AG4%2B%24AK4%2B%24AN4%2B(%24AP4%2F10)%2B(%24AQ4%2F8)%2B(%24AS4%2F2))%2F7))))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EHow%20do%20I%20imbed%20documentation%20to%20myself%20--%20or%20to%20others%20that%20may%20use%20this%20worksheet%20--%20within%20(but%20invisible%20to)%20the%20formula%20what%20each%20element%20of%20this%20decision%20tree%20does%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2027249%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

When I am programming in any assembler language, it is common practice to embed descriptions of what a sub-routine or command is intended to do.

 

Is there a way to insert documentation text into a formula without it printing on the monitor or being included in calculations within the formula itself?

 

For example:  This is a formula I use within a spreadsheet to help me make specific decisions using discreet known data.  The first 3 rows are column headers.  Cells A4 through AS53 is data, and Cells AT4 through BI53 are a series of decision trees.  This specific example is cell AY4.

 

Even though I wrote this part of the decision tree, I find it difficult to remember what each step does -- and therefore, it is difficult to edit or modify it for specific uses.

 

=IF($A4="","",IF($AX4="Pick",0,IF($AX4=$A4,(((IF(AND($E4=0,$F4=0),1,($D4+($F4/2))/($D4+$E4+$F4)))+$L4+$P4+$S4+($U4/10)+($V4/8)+($X4/2))/7),(((IF(AND($Z4=0,$AA4=0),1,($Y4+($AA4/2))/($Y4+$Z4+$AA4)))+$AG4+$AK4+$AN4+($AP4/10)+($AQ4/8)+($AS4/2))/7))))

 

How do I imbed documentation to myself -- or to others that may use this worksheet -- within (but invisible to) the formula what each element of this decision tree does?

0 Replies