I'm a novice to Excel. I don't which formula to use. I want to set up a budget for 12 months, that quite easy ex. 12000/12= 1000 in 12 columns. I need a formula for when one column answer is changed by hand lets say to 2000, that will the remaining columns answers automatically change to 909.09. I don't which formula to use and if its do able?
Thanks for your help
Kind regards
Johan
You could add a helper column in which you keep track of the manually entered values. Let's say the Total value (12000) is in A1, months are in column A2:A13 and the helper column is column C. Column B would then be; =IF(C2<>"",C2,(A$1-SUM(C$2:C$13))/(12-COUNT(C$2:C$13)) for cell B2, simply extend to the other cells in column B