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

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 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.

Explanation / Answer

fIND THE CODE BELOW:

you can give like the below formula for your condition.

=IF(AND(F3="FALSE",G3="FALSE",H3="FALSE"),"Do Not Include",IF(OR(G3="TRUE",H3="TRUE"),"GET MORE DATA","ALLOW TO BID"))

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---