I'm not sure this is possible. Maybe VBA?
Ex 1: I want to select A3 (Turn Down Ratio), B3 (Number of sets), and C3 (Full Scale). Then in column E it will divide the Full Scale into 5 sets by the Turn Down Ratio in A3.
Then shown in Ex 2, if I change the Value in A3 and B3, it will then divide C3 by 8 sets in B3 and now a 5:1 turn down based on A3.
I currently have a spreadsheet that will automatically turndown the full scale but only a fixed sets of 5.
Ex 1: I want to select A3 (Turn Down Ratio), B3 (Number of sets), and C3 (Full Scale). Then in column E it will divide the Full Scale into 5 sets by the Turn Down Ratio in A3.
Then shown in Ex 2, if I change the Value in A3 and B3, it will then divide C3 by 8 sets in B3 and now a 5:1 turn down based on A3.
I currently have a spreadsheet that will automatically turndown the full scale but only a fixed sets of 5.

