how to use Loop for calculating number

**rishikrsaw** · 03-23-2017, 07:33 AM

Hi There,

Please help me to calculate equation using loop

Equation below

1^p + 2^P........... N^P

I want to use inputbox for P and N

and sum value of this equation would came in msg box

I had tried but somewhere I stop

Here attached is the sheet Kindly help me

ThanksUntitled.png

**Phuocam** · 03-23-2017, 07:41 AM

Try this ...

Please Login or Register  to view this content.

**rishikrsaw** · 03-23-2017, 08:06 AM

not working

**rishikrsaw** · 03-23-2017, 08:12 AM

I had use below and got my result

Please Login or Register  to view this content.

how to use Loop for calculating number

LinkBack

Thread Tools

Rate This Thread

Display

how to use Loop for calculating number

Re: how to use Loop for calculating number

Re: how to use Loop for calculating number

Re: how to use Loop for calculating number

Thread Information

Users Browsing this Thread

Similar Threads

Calculating number of times individual number appears in a pivot table

[SOLVED] calculating a row with loop function not working

[SOLVED] Loop for calculating the sales for a given area and a commodity

[SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number

Do-While loop within a do-while loop? Dealing with changing number of rows

VBA For loop where number of iterations can be changed from inside loop

Macro loop Problem (Calculating persons age)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions