VBA editor or IF function? -

[Robert_G]

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.

 

[Legacy 143009]

Nice challange

Paste this formula to E3 and copy down:
=IF(ROW()<$B$3+3,$C$3-((($C$3-($C$3/$A$3))/($B$3-1))*(ROW()-3)),"")

However, second scenario resulting different than yours somehow...

 

[Robert_G]

Thanks. Your equation is correct and my copy and past on the second scenario above was copied wrong. Thanks for your help, worked like a charm. I don't know why I had such a mental block with this.

 

[Legacy 143009]

Thanks. Your equation is correct and my copy and past on the second scenario above was copied wrong. Thanks for your help, worked like a charm. I don't know why I had such a mental block with this.

Sometimes you stuck... I am sure there are several shorter ways to calculate these kind of problems but I come up with a longer solution. No problem