Sum of Powers

Basic Exercise

Statement

Create an application that will calculate the output of the function $S=N+N^{2}+N^{3}+...+N^{M}$ where $N$ and $M$ are positive integers inputted by the user

Suggested Concepts:

Dim - Declares variables.
For Next - Repeats a group of statements a specified number of times.
Function - Function will return a value.

Remember that in most cases there is more than one way to solve the exercise.

Hint: Create a Loop that runs from 1 to $M$. Every new term equals $N$ raised to the $i$^th power

Solved Exercise

Exercise Solution

We start by defining the arguments of the function and the output data type
```
Function SuMPoW(N As Long, M As Long) As Double
```
We declare the variables
```
Dim i As Long
Dim Prog As Double
```
We create a For...Next loop from 1 to $M$ where the number of the iteration equals to the exponent
```
For i = 1 To M
    Prog = Prog + (N) ^ i
Next i
```
Finally, we define the output of the function as the "Prog" variable
```
SuMPoW = Prog
```

Consolidated Answer

    Function SuMPoW(N As Long, M As Long) As Double

    Dim i As Integer
    Dim Prog As Double

    For i = 1 To M
        Prog = Prog + (N) ^ i
    Next i

    SuMPoW = Prog

    End Function

Show Answer

Download exercise Download answer

SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

INTRODUCTION

BASIC

INTERMEDIATE

ADVANCED