The file named Problem26data.xlsx contains sales data on the worlds 2,000 largest companies. If an integer between

Question:

The file named Problem26data.xlsx contains sales data on the world’s 2,000 largest companies. If an integer between 1 and 2000 is entered in cell B3, then cell C3 should return a sentence such as The company ranking #1 in revenue has revenue of $328.21. Use the TEXT function to ensure the dollar amount has the proper format.

image

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: