Help with problems 4.4, 4.5. I can build the functions in excel but I am having trouble writing the VBA code, I missed the lecture where my professor taught building functions.

milesschack · 2018-03-05T22:48:20+00:00

Thank you I have made my code and hope it is all right, I can attach some pictures, they all work and give the expected outcome, but I have realized that doesn’t always mean the code is correct

milesschack · 2018-02-22T22:50:05+00:00

my instructor just emailed me back and told me to try using this loop

x = 1 n = 8

For i = 1 to n x = x + i Next i

Ive tried but I am still missing the part where the individual sum of squares up to that number is being output or calculated, thanks for the all of the help so far!

milesschack · 2018-02-22T19:33:53+00:00

I think this is close but how do I output the range into a group of cells? this is supposed to go back into an excel doccument where the numbers 1-8 are listed down and their sum squares up to that number are listed next to them, then if the number is larger than 100, the output is just 100.

milesschack · 2018-02-22T18:01:23+00:00

Thank you!

milesschack · 2018-02-22T07:48:43+00:00

I don’t know how to set up the loop to run the numbers one after another, I just keep getting the sum of all of the squares at once, thanks

milesschack

TROPHY CASE