Hi all, I can't find how to do this in the docs; not even sure it's possible but seems like it should be.
Assume column A is named "foo" (select column, insert/name/define) In column B I can use the corresponding element in the same row in A in a formula by using its name, e.g. =foo*3 Is there a way to reference a cell in column "foo" (A) relative to the row in which the formula is being defined? What I want to do is subtract the previous row value from the current row one: =foo - [foo-1] How do I say that? Thanks, Gary --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
