richard_d1
New Member
- Joined
- Feb 7, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hello,
I know how I would do this in a programming language, I'd use a for-loop, but I'm not sure how to do it in Excel. An array formula maybe?
If the user enters the value 3 in cell A1, then I want a formula which will give = ROUNDUP((1*250)/350,0) + ROUNDUP((2*250)/350,0) + ROUNDUP((3*250)/350,0)
Whereas if they'd entered 2, it would only have done it twice, if they entered 10, it would do it ten times, etc.
Thanks.
I know how I would do this in a programming language, I'd use a for-loop, but I'm not sure how to do it in Excel. An array formula maybe?
If the user enters the value 3 in cell A1, then I want a formula which will give = ROUNDUP((1*250)/350,0) + ROUNDUP((2*250)/350,0) + ROUNDUP((3*250)/350,0)
Whereas if they'd entered 2, it would only have done it twice, if they entered 10, it would do it ten times, etc.
Thanks.