275,146 views
3 votes
3 votes
.

In cell J5, enter a formula using the OR function that tests whether the location is
equal to "N" or whether the plan type is equal to "Unlimited".

. In cell J5, enter a formula using the OR function that tests whether the location-example-1
User Guy Dubrovski
by
3.0k points

1 Answer

10 votes
10 votes

Answer:

=IF(OR(C5="N",G5="Unlimited"),TRUE,FALSE)

Step-by-step explanation:

There is an OR function contained within the IF function. The OR statement will return "TRUE" if either C5="N" or G5="Unlimited". If one of these conditions is true, the result will be "TRUE." Otherwise it will return "FALSE."

User Katie
by
3.3k points