I got this far but for some strange reason
I cannot display the formula in a cell.
All I get are the results of the formula.
How do I see the hidden formulas that gave these results?
Of course I can retype the formulas because I know
what they are. I don't want to do that over and over.
I can copy then with relative addressing if I could get
them to appear.
Seems life would be a lot simpler if cells had two sections.
One section to hold the formula and the other to hold
the results of the formula instead of hiding the formula
in the same cell.
Paul Lamar ...No rotor no motor.
Hi Paul,
When you select the cell, the results are in the cell, but the actual
formula is in the window at the top. If you want to copy the formula
with relative addressing, just select the cell, cntrl-c, select the
range you want to copy it to, cntrl-v.
If you want to fix either the row or columns, add a $ in front:
=$A$1*B1 will always multiply the cell you copy to, relative to B1, to
the contents of A1 for example.
Bob W.
--
http://www.bob-white.com
N93BD - Rotary Powered BD-4 (projected engine start in November)
Custom Cables for your rotary installation -
http://www.roblinphoto.com/shop/
For some strange reason the formula is not in the window up
top. Only the value. What the heck is going on?
I know about the absolute addressing.
I ave a lot more constant speed fuel consumption data I want
to load into this sheet.
Paul Lamar ...No rotor no motor.
The Rotary Engine NewsLetter. Powered by Linux.
ACRE NL web site.
http://www.rotaryeng.net
Copyright 1998-2005 All world wide rights reserved.