Question: I need help writing a formula for question 2 thanks 2. Write a formula in column I that can be copied down the column to

I need help writing a formula for question 2 thanks

I need help writing a formula for question 2 thanks 2. Write

a formula in column I that can be copied down the column

2. Write a formula in column I that can be copied down the column to make a final determination of "Allow to bid," "Do not include," or "Get more data" based on the following criteria Recommend to "Do not include" if none of the rules are TRUE. Recommend to "Get more data" if only Rule #2 is TRUE or only Rule #3 is TRUE Recommend to "Allow to bid" if the bidder is not recommended as "Do not include" or "Get more data." TROUBLESHOOTING: To complete this exercise, be sure to use parentheses in pairs and commas to separate arguments. It is very easy to misplace, fail to include, or include extra parentheses and commas when entering this type of complex formula, resulting in error messages or incorrect values. Excel color coordinates the pairs of parentheses, making it easier to spot errors

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!