Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the figure shown below, column B contains some numbers representing a category to which a buyer belongs. Don't worry about what this means. The

In the figure shown below, column B contains some numbers representing a category to which a buyer belongs. Don't worry about what this means. The person who created this spreadsheet wants to place new category values in column C. Column C should have 200 if column B has 35. It should have 225 if column B has 15 and so on as per the values on columns E and F. The formula that will accomplish this for cell C2(using E1:F6 as a lookup table) and can be copied for the remaning cells in column C is

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

More Books

Students also viewed these Databases questions

Question

7. Discuss the key features of the learning organization.

Answered: 1 week ago