Question: Write a VBA code to calculate significant digit for an approximation. Specific requirements: 1. Use two input boxes to acquire the input for true value

Write a VBA code to calculate significant digit for an approximation. Specific requirements:

1. Use two input boxes to acquire the input for true value and approximation value, respectively.

2. Calculate relative error.

3. If relative error is equal or greater than 0.5, pop up a message "Error is too much! No significant digit!".

4. If relative error is less than 0.5, calculate the approximation significant digit and present it in a message box.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...

Q:

So I can make the flowchart but not sure how to make the VBA code. It's all super foreign to me 13.5 VBA Project: Olympus Tours You have just been hired by Olympus Tours (OT), a bus rental company...

Q:

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Q:

In C++ please. Assignment 4 This assignment is the first in a sequence of three. It is not strictly necessary to complete this one in order to do the other two, but the understanding you gain in...

Q:

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Q:

This assignment is the first in a sequence of three. It is not strictly necessary to complete this one in order to do the other two, but the understanding you gain in completing this assignment will...

Q:

Problem Description The assignment is meant as an introduction to Java programming and is partially structured as a tutorial. To solve this assignment you will have to make use of concepts we havent...

Q:

1411116 - Programming I Assignment #3 Due Date: November 30, 2016 Submission Instructions: Submit your assignment on the blackboard link, corresponding to your Section: Please follow the following...

Q:

I have a attached a copy of the data used to answer the question Prepare a 2007 classified balance sheet and multistep income statement. Use the account balances from the unadjusted trial balance and...

Q:

Sandle Corporation, an accrual-basis, calendar-year taxpayer, sold $15,000 of its products on account to Jim in November, year 1. In year 2, Jim declares bankruptcy and Sandle writes off the account...

Q:

The drug mechktrethamine is used in antitumor therapy. It is one of a family of compounds called nitrogen mustctrds, which also includes the antitumor drugs cyclophosphamide and chlorambucil. (a)...

Q:

There are two economy situations and three stocks. Information is as follows Economy Stock A Stock B Stock C Booming 0 . 3 1 0 % 2 0 % 5 % Recession 0 . 5 0 % - 1 0 % 3 % 2 b . There are three...

Q:

True or false: Expenses that result from operating the business decreases the stockerholder's equity?

Q:

4. Go to www.keirsey.com. Complete the Keirsey Temperament Sorter or the Keirsey Character Sorter. (You will have to register first.) These are examples of assessment instruments that can be used for...

Q:

2. Performance expectations: A description of competencies, performance results, and major job experiences required to succeed at each level of the company.

Q:

4. Why do companies develop formal mentoring programs? What are the potential benefits for the mentor and for the protg? What is the best way to match mentors and protgs?