Write a function that calculates integer exponent function

Assignment Help Programming Languages

Reference no: EM131708537

Assignment: Integer Exponent Function

The exponentiation operator (^) is used to raise a number to a power. If the exponent is an integer >= 0, then:

x^0 = 1
x^1 = x*x^0
x^2 = x*x^1
x^3 =
       .
       .
       .
x^n = x*x^(n-1)

1. Write a Function procedure that calculates xⁿ using a For-Next Loop instead of the exponentiation operator. Your function will accept two input arguments: n (any integer >= 0) and x (any real floating-point number), and will return the result xⁿ.

2. Validate that the integer input value is valid.

a. If it is valid, your function will return the resulting value of xⁿ

b. If it is not valid, your function will return the following error code, using the VBA built-in error function:

CVErr(xlErrValue)

Where "xlErrValue" is the VBA built-in constant that results in function "CVErr" returning the error code "#Value!".

3. Test your function on a worksheet, with two clearly labeled and named input cells for values of x and n, and one clearly labeled output cell where you will use your function.

Reference no: EM131708537

Questions Cloud

Conduct an environmental scan for your company : Conduct an environmental scan for your company focusing on which of the five external forces the company is likely to be impacted by.

Explain rather deal with in a negotiation : Who would you rather deal with in a negotiation, a fence sitter or a bedfellow. Personally, I would rather deal with a fence sitter since the fence

Paper about the identity of person who is living in country : My big idea for this paper is to spread awareness about the identity of a person who is living in a country other than from his home country

What is explicitly geographical about the application : What form of GIS data representation would be most suitable vector or raster, What is explicitly geographical about the application

Write a function that calculates integer exponent function : Write a Function procedure that calculates Integer Exponent Function using a For-Next Loop instead of the exponentiation operator.

Summarize the methods the team used to develop solutions : Summarize the methods the team used to develop creative solutions. Describe ways the team overcame barriers to creativity to identify solutions.

Describe the three topics that were most interesting : Describe the three topics that were most interesting to you throughout this course

Discuss the secession of the south from the union : From 1848 to 1860, the nation experienced a series of political events which resulted in the secession of the South from the Union

Discuss the influence the decision-making process had : Develop a evaluation of a recent business decision in your work or desired career. Discuss the influence the decision-making process had on the outcome.

User Account

All Pages