I actually need it for a much more complex formula I just wanted to know if I there was a built-in excel function that allows a group of cells to be linked by a common formula of which each cell is assigned a specific part of the formula so that changing any one value will change the rest in that group but as it turns out, there isn't.
If you could provide a small example sheet with what you want to do ,we could probably find a solution to your problem