I am trying to use a formula that subtracts one column from another and divides by the first. I have that working fine even if one of them is empty. What I want to do is set up a group of reference cells so that as the month changes (and therefore the column) I can type in one cell, which column to use and all my formulas update automatically. I tried using match and it gives me an offset, but I can't figure out how to use that to update a cell reference. Can you help? Thanks for any help you may have to offer.
cell reference formula



Re: cell reference formula
Hi
Probably need more data on your setup, but assuming that you have data in A2, A3, A4... and the formula you are using is
then if you put a number in A1 you could do something like
This always assume you are subtracting from column A and dividing by column A. If you want to change both the nominator and divisor then can you give more details of your setup? Perhaps a sample file?

Re: cell reference formula
Can you post your sheet? Would be easier for us.

Re: cell reference formula
Wigi:
Thank you. I needed to use offset multiple times but you gave me enough to get it to work. Thank you again.
Zylstra

Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!