Determine the sum of all integers that are evenly divisible

Assignment Help Computer Engineering

Reference no: EM132175750

For VBA:

The user (me) will input two positive integers into cells C3 and C4 on Sheet1.

Create a run button on Sheet1 that executes a macro named problem1. This macro performs the following tasks:

· Obtain the two integers A and B from cells C3 and C4 on Sheet1, then check is A is less than B. If A is greater than B, tell the user that A needs to be smaller than B then end the program.

· Use a For loop to determine the sum of all even integers from A to B.

· Use a For loop to determine the sum of all odd integers from A to B.

· Use a For loop to determine the sum of all integers that are evenly divisible by 5 from A to 2*B.

For example, if A is 2 and B is 11, then the sum of even numbers (2+4+6+8+10) would be 30, the sum of odd numbers (3+5+7+9+11) would be 35, and the third sum (5+10+15+20) would be 50.

Output the smallest of the three sums to cell E6, the middle sum in cell E7, and the largest of the three sums to cell E8.

You may solve this problem by using as many For loops as you like, but do not use Do loops.

Use the Option Explicit statement for this macro. Highlight and label the cells where the user must input data and the cells where data will be output by the macro.

Assume the user will input all necessary values on the worksheet before clicking the run button.

Reference no: EM132175750

Questions Cloud

How does exploiting get you to remediation : Along those lines, what do you consider to be the ultimate goal of a penetration test? Can you stop short of actually exploiting?

How many different passwords are there : A valid password is a string of between 6 and 12 characters, inclusive, where each character can be an uppercase or a lowercase letter.

Create a custom multi-converter : There will be eight text boxes. Four of them will represent the decimal values of the current color (each between 0 and 255 inclusive).

Write a java console application that manages city names : Write a Java console application that manages city names. Use an array of size 30 to store the names.

Determine the sum of all integers that are evenly divisible : Use a For loop to determine the sum of all integers that are evenly divisible by 5 from A to 2*B.

What minimum number of clicks he has to make in order : Vasya has found a strange device. On the front panel of a device there are: a red button, a blue button and a display showing some positive integer.

How long would it take the rover to transmit the pictures : Suppose NASA takes several pictures of the martian surface and wants to transmit them back to Earth. The total size of the pictures is 50 MB.

Analyze the asymptotic number of moves your algorithm : Develop a divide and conquer algorithm for moving n disks from tower 0 to tower 2.

Write 100 integers created randomly into the file : Write 100 integers created randomly into the file using text I/O. Integers are separated by spaces in the file.

User Account

All Pages