Loop formula to sum results

[richard_d1]

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.

 

[Fluff]

How about

=SUM(ROUNDUP((SEQUENCE(A1)*250)/350,0))

 

[richard_d1]

How about

=SUM(ROUNDUP((SEQUENCE(A1)*250)/350,0))

Ah; SEQUENCE is the function I need.
Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.