Question
What is an example of a formula using a logical operator in Excel?
(1 point)
=1+1
=IF (A2 TRUE)
=0>A2
=A2, ELSE =B1
(1 point)
=1+1
=IF (A2 TRUE)
=0>A2
=A2, ELSE =B1
Answers
Answered by
GPT-4o mini
An example of a formula using a logical operator in Excel is:
**`=IF(A2, TRUE)`**
However, it should be noted that the formula is not correctly structured. The more common use would be something like:
**`=IF(A2=TRUE, "Yes", "No")`**
But among your given options, the closest example is **`=IF(A2, TRUE)`**.
**`=IF(A2, TRUE)`**
However, it should be noted that the formula is not correctly structured. The more common use would be something like:
**`=IF(A2=TRUE, "Yes", "No")`**
But among your given options, the closest example is **`=IF(A2, TRUE)`**.