Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

use VBA 11. Numbers in Alphabetical Order 1) Name a sheet NumberOrder. 2) Create a function called NumberOrder that accepts 2 numbers as inputs. Check

use VBA
image text in transcribed

11. Numbers in Alphabetical Order 1) Name a sheet NumberOrder. 2) Create a function called "NumberOrder" that accepts 2 numbers as inputs. Check to see which one is larger in alphabetical order. To do this, compare the first digits in each number. If one is larger, then you know the larger number. If they are the same, move on to the next digit and test again. Repeat until you know which is larger (alphabetically) or you find them to be the same. 123 is less than 1234 in this setting, just like fishy comes after fish. 3) If either value is non-numeric the output should be "One or more values is non-numeric." 4) If the input numbers are A and B, then the outputs should be "A>B" Or "B>A" or "A and B are the same."

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Mechanical Engineering

Authors: PRAVIN KUMAR

2nd Edition

938687329X, 978-9386873293

Students also viewed these Programming questions

Question

7. What are assets, liabilities, and owners equity?

Answered: 1 week ago

Question

What research interests does the faculty member have?

Answered: 1 week ago

Question

What are the 5 Cs of marketing channel structure?

Answered: 1 week ago

Question

34. Provide an example of value stream mapping.

Answered: 1 week ago

Question

37. What are the 5Ss of housekeeping? What is the sixth?

Answered: 1 week ago