I have this code started in C12 and continues down to C31......
=IF(ROW()<$D$4+12,$F$4-((($F$4-($F$4/$B$4))/($D$4-1))*(ROW()-12)),"")
There's a few things going on here but essentially the value will "turn down" in division based on a value in B4 and Full Scale in F4.
I was thinking how...