Weight and Balance Formula, Can one calculate the envelope

wrote in message
om...
You will need a bunch of "if-then" statements to define the acceptable
envelope(s). Look it up on Excel Help. Lotsa luck though as the same
guys must write the help as write the original software package.


I have an Excel worksheet with NO if-then statements anywhere.
I used the data from the pilot's handbook to determine the corners
of a graph that represents the W&B envelope. Then I built a table
duplicating the W&B factors from the handbook along with the calcs for the
moment arms. Down at the bottom where the weights and moment arms are
totaled, I transfer them to the graph using an asterisk symbol to represent
the single data point.
Would you please give me an example of a couple if-thens you used,
please?