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


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
Get step-by-step solutions from verified subject matter experts
