Try it! Suppose that a manufacturing company buys raw materials from a supplier. If the cost in any month is $x, the company pays 40% of this cost one month from now and the other 60% two months from now. Use the OFFSET function to calculate the payments made in January through August in the green cells to the right, based on the costs through July. These calculated payments should change automatically if you change the inputs in the blue or red cells above. For example, make sure your formulas react correctly if you enter 2 and 3 in the two red cells. (Scroll to the right to see the answer.) Percent paid 40% when: 60% 1 month from now 2 months from now Aug Month Cost Payment Oct $1,950 Nov $2,900 Dec $4,150 Jan $2,500 Feb $3,350 Mar $2,850 Apr $3,550 May $1,850 Jun $4,200 Jul $2,300