Question: How to write formula to display text depending on value. Ex) If 1, then NYSE. If 2, then AMEX. If 3, then NASDAQ. If 0

How to write formula to display text depending on value.

Ex) If 1, then NYSE. If 2, then AMEX. If 3, then NASDAQ.

If 0 to 3000, then Manufacture. If 3001 to 7000, then IT. If 7001 to 9999, then Retail.

Thanks!

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 Finance Questions!

Q:

Design awebsite of your choice .. Most of what has been studied must be applied to the site . HTML heading : Headings are defined with the to tags. defines the most important heading. defines the...

Q:

answer this workbook please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/EQNuFz9ESMBBi1zuzV0w9uYB2I2aaFXcclMlPPc6JndcLQ?e=12fYP0 18 19 Horizontal Analysis 0...

Q:

Retirement Planning Worksheet: 50 points In this problem, we want to estimate someones income in retirement based on several variables: the amount of money being saved, the number of years they plan...

Q:

Please show formula values.. Garca and Martinez manufacture widgets and currently have $16 million in taxable income. The company is considering an expansion, and they've asked you to evaluate the...

Q:

Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have substantial assets and have not yet...

Q:

Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have substantial assets and have not yet...

Q:

Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have substantial assets and have not yet...

Q:

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

Q:

6.1. Carbondale Company has the following credit policy 2/10, net 30. Carbondale also charges 1% per month interest on all accounts after 30 days. The following table shows the collection schedule of...

Q:

MBA 520 Module Six Forecasting Model Questions The questions that follow and the article Comparing the Accuracy and Explainability of Dividend, Free Cash Flow, and Abnormal Earnings Equity Value...

Q:

If you a buy a house for $150,000, live in it for more than two years, and sell it for $350,000 you pay NO TAX on this $200,000 realized gain. By contrast, if you invest $150,000 in a stock and sell...

Q:

1. A complete income statement potentially has the following sections: (1 point) a. Items from continuing operations and earnings per share for a corporation. b. Income or loss from operating a...

Q:

What is African Socialism and how might it differ from socialism in general?

Q:

What type of regulator is formed by its members to attempt to influence organizations? a . strategic ally b . competitor c . regulatory agency d . board of directors e . competitor

Q:

What,in your opinion, should the store managers job description look like and what activities should it contain? Based on her review of the stores, Jennifer concluded that one of the first matters...

Q:

Whatis human resources planning and how will it help Carters strategic plans? While in college, Jennifer was especially interested in labour forecasting. She learned that a key component of HR...

Q:

Outline three quantitative techniques for forecast-ing future HR demand. Outline three strategies usedto forecast internal HRsupply. While in college, Jennifer was especially interested in labour...