Ask Question
Computers & TechnologyComputers & Technology
13 April, 06:43

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 "Drama" and [Approved?] value of "No". Fill the range G3:G23 with the formula in cell G2 Excel does not do so automatically.

+1
Answers (1)
  1. 13 April, 07:33
    0
    =IF (AND (H2="drama"; I2="No"); "TRUE"; "FALSE")

    Explanation:

    For this example, we must use the formula IF in addition the formula AND, with this combination the result.

    If the field H2 = drama AND the field I2 = NO, the field G2 it's going to be TRUE, If not, the field it's going to be FALSE.

    We could use this formula as long as we want in our Excel.

    For example: from cell G2 until cell G23.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “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 ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
Why are digital calendars considered to be a convenient way to maintain a study schedule
Answers (2)
According to records leaked to the Guardian newspaper, which of the following kinds of information were not released by Verizon to the National Security Agency?
Answers (1)
What does the / etc/shadow file contain?
Answers (1)
You are experiencing some problems with your operating system on your desktop and want to repair some problems with your hard disk. Which of the following will you use? * A. backup tool B. file compression tool C. PC maintenance tool D.
Answers (1)
Core component of the linux operating system is the linux kernel. if you were a linux systems administrator for a company, when would you need to upgrade your linux kernel
Answers (1)
New Questions in Computers & Technology
Write a program that prompts the user to enter time in 12-hour notation. The program then outputs the time in 24-hour notation. Your program must contain three exception classes: invalidHr, invalidMin, and invalidSec.
Answers (1)
Soo ... My Old 3DS XL haven't been touched in around a year ... So i tried to charge it but no LED lights opened ... Even the power button does not work ... I need Halp!
Answers (1)
Joshe is a project leader in Tiran technologies. 75 developers and analysts work under his supervision on several projects. These employees are scattered in small groups in the organization, depending on the project they are working on.
Answers (1)
Write a simple number guessing game Python program. In this code, generate a random integer between 1-10 (both included) and ask the user to guess the number in three attempts.
Answers (1)
On PayPal: I have two accounts, Account A and Account B. I added an unreloadable Visa Prepaid Gift card on Account A and sent it to Account B, but Account B was locked because I didn't add an SSN, so I couldn't accept the payment.
Answers (1)
Home » Computers & Technology » 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 "Drama" and [Approved?] value of "No".
Sign Up Forgot Password?