Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas (Excel Academy Book 1) by Ramirez Adam

Author:Ramirez, Adam [Ramirez, Adam]
Language: eng
Format: epub
Published: 2020-05-13T16:00:00+00:00

=AND(C2>20, C2=B2)

This function returns TRUE if the value of cell C2 is greater than 20, and if the values of cells B2 and C2 are equal. It returns false otherwise.

=AND(A2="Apples", C2>=30, C2>B2)

This function returns the value TRUE if the cell A2 contains the value Apples, the value of C2 is greater than or equal to 30 and its value is greater than B2. It returns false otherwise.

Common Uses

The AND function does not have too much use unless you use it with other functions. AND can extend the capability and functionality of a worksheet significantly when used with other functions. A common use of this function is its use in the IF condition to test various functions instead of one. For instance, you can nest more than one AND function within this function.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.