Forum Discussion
Solved
Excel AND Formula displaying FALSE when it should be TRUE
I'm doing the CENGAGE Excel Assignment 2. I'm supposed to use the AND Formula like this: AND([Project Type]="Drama",[Approved?]="No" in the newly created "Delay?" column. But all the results are FA...
you are missing the @ indicator telling excel to specifically compare the value on the same line. It should look like this:
=AND([@[Project Type]]="Drama",[@Approved?]="No" )
you are missing the @ indicator telling excel to specifically compare the value on the same line. It should look like this:
=AND([@[Project Type]]="Drama",[@Approved?]="No" )