Question: Both ways I write the AND function it works correctly and gets the answer, however it is being counted wrong on the SAM system. =

Both ways I write the AND function it works correctly and gets the answer, however it is being counted wrong on the SAM system.

= AND(D2="Mixed Use", E2="Loan")

=IF(AND(D2="Mixed Use", E2="Loan"), TRUE, FALSE)

Can someone help me figure out what is the correct way it is to be written?

Both ways I write the AND function it works correctly and gets

the answer, however it is being counted wrong on the SAM system.

7. The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. 3/5 Add a column to the Proposed Projects table, and determine which projects meet the criteria as follows: a. In cell G1, type Fast Track as the column heading. 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. Add a column to a table. X Create a formula using a function. In the Proposed Projects worksheet, cell G2 should contain a formula that displays "TRUE" if a project has a Mixed Use project type and a loan funding type. Copy a formula into a range. =AND(D2="Mixed Use", E2="Loan") E F G F Funding Type Funding Fast Track Grant Loan Grant Grant Tax Credit Loan Tax Credit Grant Loan Tax Credit Tax Credit Loan $ 1,500 $ 24,000 $ 12,500 $ 15,000 $ 4,500 $ 10,000 $ 15,000 $ 4,000 $ 2,500 $ 9,500 $ 6,000 $ 50,000 $ 154,500 FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE 12

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!