Hi
A1 = 12
In cell B1 I have a dynamic range =sequence(1,A1,,)
In cell C1 to B12, I have manually entered percentages (e.g. 10%, 25%, 13%)
In cell D1 I have tried to enter =B1#*C1# so i can dynamically do the math depending on the size of A1. C1 has to be manual. Is there a way of doing this?
thanks.
A1 = 12
In cell B1 I have a dynamic range =sequence(1,A1,,)
In cell C1 to B12, I have manually entered percentages (e.g. 10%, 25%, 13%)
In cell D1 I have tried to enter =B1#*C1# so i can dynamically do the math depending on the size of A1. C1 has to be manual. Is there a way of doing this?
thanks.