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.

Question

Computers & Technology

Kailee

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)

Know the Answer?

Gerardo Warren · Answer 1

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