Hi...I need some help. I have a figure, let's say $1,000, and I have four cells of data that when added together equal $1,000 ( for example: $250 + $250 + $250 + $250 = $1,000). I need to know how to be able to change the data of one cell (let's say from $250 to $175) and have the other three cells evening distribute the difference (ex. $200 + $275 + $275 + $275 = $1000).

I use excel a lot, but am no expert, so if anyone can help me, I would be so grateful!!!! Thank you!!