Alculate the square root, Write a VBA function that

Alculate the square root

Reference no: EM13314705

Write a VBA function that receives 4 numerical inputs (input1, input2, input3, and input4) and performs the following operations in the stated order:

a. Calculate the average of the numbers.

b. Calculate the square root of a.

c. Multiply b by input1

d. Divide c by "input2 + input3"

e. The function should return the result from d. Use your VBA function to calculate the results based on the following sets of input parameters:

input1 input2 input3 input4 calc'd result

1 2 15 44 ?

2 5 13 87 ?

3 6 54 12 ?

4 9 33 27 ?

5 13 52 62 ?

6 22 36 47 ?

7 11 65 18 ?

Reference no: EM13314705

Questions Cloud

Business benefits of the technologies described in the case : Write a brief summary of some of the business benefits of the technologies described in the case. Provide several examples beyond the mere automation of transaction-oriented processes. Site all outside sources using APA referencing

Charge of a laboratory for developing new : Assume that you are in charge of a laboratory for developing new or improved cutting fluids. suggest a list of topics for your staff to investigate. Explain why you have chosen those topics.

Describe your thoughts on whether chips produced : Describe your thoughts on whether chips produced during machining can be used to make useful products. Which types of chips would be desirable for this purpose?

Heat is transferred to the helium gas : Helium gas at 124.0 kPa and 359.0 K is located within a cylinder with a piston. Initially the gas occupies 0.5200 m3. While a constant force, F, is applied to the end of the piston so that the pressure inside the cylinder is held constant at 124.0 kP..

Alculate the square root : Write a VBA function that receives 4 numerical inputs (input1, input2, input3, and input4) and performs the following operations in the stated order:

What was the old monthly production : After buying 10 more welding machines, a tank fabricator, increased its monthly production by 20%. If the production increased by 16 tanks, what was the old monthly production?

Uniform board of length land mass : Uniform board of length Land mass M lies near a boundary that separates two regions. In region 1, the coefficient of kinetic friction between the board and the surface is mu_1, and in region 2, the coefficient is mu_2.

Develop alternatives for resolving ethical issues : "George Green is president of Gamma Construction Company which is in the process of putting together a written bid to build a new hotel for Global Hotels. It is clear to everyone that Gamma’s chief competitor, Sigma Construction Company, will also be..

The hypothesis of continental drift is not supported by : The hypothesis of continental drift is NOT supported by

User Account

All Pages