Not sure of your exact circumstances, but assuming the input cell is A1, the cells to change are A2:A4, and the static total is in A5, you can use in cell A2:
=(A$5-A$1)/3
Then copy down to cells A3 and A4.
Not sure if this helps; let us know whether it does.
Jason
Bookmarks