They test whether or not the output from two or more target cells meets the conditions you specify.
Otherwise, it returns FALSE as a value.
Meanwhile, the OR function returns a TRUE response if any of the tested formulas are true.
200degrees/ Getty Images
It gives a FALSE value only if all the formulas are not true.
These TRUE or FALSE answers can be displayed as-is in the cells where the functions are located.
In this article’s images, cells B2 and B3 contain an AND and OR function, respectively.
The same steps can be used for entering the OR function located in cell B3.
Google Sheets does not usedialog boxesto enter a function’s arguments the way Excel does.
pop in theequal sign(=) followed by the functionAND.
When the function AND appears in the box, press the name with the mouse pointer.
As in Excel, a comma is inserted between the function’s arguments to act as a separator.
choose a cell in the worksheet to enter this cell reference as thelogical_expression1argument.
Using the main image as an example, you would select cell A2.
jot down< 50after the cell reference.
key in acommaafter the cell reference to act as a separator between the function’s arguments.
select cellA3in the worksheet to enter this cell reference as thelogical_expression2argument.
throw in<> 75after the cell reference, followed by another comma.
hit cellA4in the worksheet to enter the third cell reference and punch in>=100.
Press theEnterto complete the function.
To enter the OR function, repeat the above steps using=ORinstead of =AND.
