Forum Discussion
micro excel
I am having trouble with offset input/output reference
Hello @ tonyaterrell73
Can you elaborate a bit more of what you are trying to accomplish? Not enough information here.
Offset is a way to tell MS-Excel what to do with the cell left, right, up or down from the cell you are referencing. For example:
=OFFSET(A1,9,2) will get the value of the cell C10 cell C10 is 9 rows below cell A1 (1+9=10) and 2 Columns to the Right of cell A1. (A-B-C).
There are other parameters for the OFFSET function, but for now I need to keep it simple.
For the "input/output reference" I can't tell what you mean.
Hope this helps
Georgie
Can you elaborate a bit more of what you are trying to accomplish? Not enough information here.
Offset is a way to tell MS-Excel what to do with the cell left, right, up or down from the cell you are referencing. For example:
=OFFSET(A1,9,2) will get the value of the cell C10 cell C10 is 9 rows below cell A1 (1+9=10) and 2 Columns to the Right of cell A1. (A-B-C).
There are other parameters for the OFFSET function, but for now I need to keep it simple.
For the "input/output reference" I can't tell what you mean.
Hope this helps
Georgie