Hi everybody, kind of new to excel and I'm having trouble figuring this one out.
I have a row of percentages that all start at 40%.

A B C D E F G H I J K L
1 40% 40% 40% 40% 40% 40% 40% 40% 40% 40% 40% 40%

I want to be able to change one of the numbers and have all subsequent numbers remain constant.
So for example I'd like to change D1 to 30% and have all subsequent cells then also change to 30%.

A B C D E F G H I J K L
1 40% 40% 40% 30% 30% 30% 30% 30% 30% 30% 30% 30%

And then say I change H1 to 20% so all subsequent cells would then change to 20% as well.....and so on.

A B C D E F G H I J K L
1 40% 40% 40% 30% 30% 30% 30% 20% 20% 20% 20% 20%

Is there an easy formula to accomplish this?
Many thanks!