- 1). Click inside the cell that you want to contain the "AND" function.
- 2). Type "=AND" followed by a left parenthesis. This tells Excel that you are beginning an "AND" function.
- 3). Type the first logical test you want Excel to perform. Do not include a space between the parenthesis and the beginning of the statement. If your condition tests whether a certain string of text is present in a cell, the string must be put between quotation marks. For example, =AND(A3=Jones) is not a valid test; =AND(A3="Jones") is.
- 4). Type a comma after the first test, followed by another condition, if desired. You may add up to 255 logical tests in Excel 2010.
- 5). Add the closing parenthesis mark, and press "Enter." The function will return either "true" if all of the conditions are met or "false" if one or more of the conditions are not met.
previous post
next post