Is there a way to set a formula to refer to the row above similar to Excel?
E.g If i am in cell G8, i want the fromula to be something like G7 - E8?
I figured this out.
Cheers
I'm trying to figure this very thing out myself. Could (or anyone else) post the solution for others like myself who are curious about this?
Okay: I found a help topic that answers my question. Search for the topic "Using WinCalcManager to Create Running Totals in WinGrid " and item #5 talks about relative references. (Nice touch by the way in mentioning how to preven errors with referecing prior row vaules in the first row.)
Thanks and happy coding. :)