Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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?
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 12Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started