Evaluate the formula =AND(G2="FT",M2=1) based upon the information provided.
-What value is returned assuming that G2 contains the value FT and M2 contains the value 2?
A)TRUE
B)FALSE
C)PT
D)PT, 2

Question

Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided.
-What value is returned assuming that G2 contains the value FT and M2 contains the value 2?
A)TRUE
B)FALSE
C)PT
D)PT, 2

Quizplus · Accepted Answer

The formula evaluates whether both conditions are true, i.e, G2 is equal to "FT" and M2 is greater than or equal to 1. Since G2 contains "FT" and M2 contains 2 which satisfies both conditions, the formula will return TRUE.

Evaluate the Formula =AND(G2="FT",M2>=1) Based Upon the Information Provided