How do you use logical operators in Google Sheets?

 All you need is to use the category 'Function->Logical' in the drop-down of the Insert Menu item shown here:

   

You can choose the operator you want such as 'AND'

AND operator takes two arguments and provides the result. Read the explanation that shows up as a drop-down.

Exaample 1: I have three numbers in three cells as shown

In the above you can see B1 is > than B2 and the answer is true.

Example 2: You need not give cell references to evlauate the result of an AND operation as shown below. Obviously, the result of 1>100 is 'false'

The following from the link 'Learn more' above.

AND function

The AND function returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.

Sample Usage

AND(A2 = "foo", A3 = "bar")

AND(TRUE,FALSE,TRUE)

AND(A1:A10,B1:B10)

AND(0,1,2,3)

Syntax

AND(logical_expression1, [logical_expression2, ...])

• logical_expression1 - An expression or reference to a cell containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value.

• logical_expression2, ... - [ OPTIONAL ] - Additional expressions or references to cells containing expressions representing some logical values, i.e. TRUE or FALSE, or expressions that can be coerced to logical values.

Notes

• The number 0 is logically false; all other numbers (including negative numbers) are logically true.

See Also

OR: The OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

NOT: Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.

Examples

Returns TRUE if all arguments are TRUE, returns FALSE if any element is FALSE, accepts both logical_value and range parameter.

How do you work with statistics in Microsoft Excel?

Microsoft Excel makes it ridiculously easy to work with statistics. Excel has a number of built-in functions that you can use relatively easily. These are backed up with enough documentation to use the functions.

These four steps show how:

Access Add a function using fx:

Insert function window opens as shown.

In the Insert Function window scroll down the drop-down list and choose 'Statistical'. This has a long list of functions available.

Let us take an example of the function 'Trend'

Scroll down the available function list till you get to 'Trend' as shown.

Click  the 'Help on this function' link. The web page (https://tinyurl.com/y5r94tp5) for this function opens. A part of this page's image is shown here:

If the tiny URL does not work, try this ugly link:

https://support.microsoft.com/en-us/office/trend-function-e2f135f0-8827-4096-9873-9a7cf7b51ef1?ns=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60098&ui=en-us&rs=en-us&ad=us