Question

B. In cell G2, enter a formula using the AND function that includes structured references to display TRUE if a project has a [Project Type] of "Mixed Use" and a [Funding Type] of "Loan". Fill the range G3:G13 with the formula in cell G2 if Excel does not do so automatically

Answer 1

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell G2 is = IF(AND(D2 = "Mixed Use", E2 = "Loan"), "True", "False")

How to determine the Excel formula

From the question, we have:

• Cell D2 represents [Project Type]
• Cell E2 represents [Funding Type]

The Excel AND function is represented as:

= IF(AND([condition 1],[condition 2]), [Value if true], [Value if false])

So, we have:

= IF(AND(D2 = "Mixed Use", E2 = "Loan"), "True", "False")

Hence, the Excel formula to enter in cell G2 is = IF(AND(D2 = "Mixed Use", E2 = "Loan"), "True", "False")

Read more about Excel formulas at:

https://brainly.com/question/14820723