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 and Technology

Marilyn Vaughan

18 November, 18:13

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.

+5

Answers (1)

Know the Answer?

Gavyn Knight · 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.