cell reference formula

  • 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.

  • Re: cell reference formula


    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

    Quote from zylstra


    Thank you. I needed to use offset multiple times but you gave me enough to get it to work. Thank you again.


    Credits go to Acw : D



    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Participate now!

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