Sharing Information: Tutorial : And Function

Tutorial : And Function - Excel

9:18 PM |

Diposkan oleh Fiola |

The And Function is used to display True or False depending on certain conditions.

To begin, let’s take a look at the syntax below.

And( condition1, condition2, … ) : The condition is what we would like Excel to determine True or False.

Take a look at the example below.

10 =AND(A1>1, A1<20) : True

Ohio State =AND(A1=30, A2=”Michigan”) : False