{"id":104,"date":"2017-07-06T17:36:56","date_gmt":"2017-07-06T17:36:56","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/?post_type=chapter&p=104"},"modified":"2017-07-06T18:20:05","modified_gmt":"2017-07-06T18:20:05","slug":"and-function-for-spreadsheets-information","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/atd-tc3-spreadsheets\/chapter\/and-function-for-spreadsheets-information\/","title":{"raw":"AND function for Spreadsheets: Information","rendered":"AND function for Spreadsheets: Information"},"content":{"raw":"

OVERVIEW<\/b><\/span>:<\/b><\/p>\r\n

Where to find AND function<\/b>:\u00a0 <\/span>FORMULA<\/b> tab, Logical<\/b> in the Function group, then find AND<\/b> in the pull down menu.<\/p>\r\n

Purpose of AND function<\/b>:\u00a0 <\/span>To evaluate all of its arguments.\u00a0 <\/span>It returns, or displays\u00a0 <\/span>True<\/b> for every<\/b><\/span> logical test in the formula..<\/p>\r\n

Return Value<\/b> \u2013 the result of the evaluation is TRUE or FALSE<\/p>\r\n

Syntax:<\/b>\u00a0 <\/span>=AND (logical test, [value all values TRUE],[if one or more value is not true FALSE)<\/p>\r\n

Arguments<\/b>:<\/p>\r\n

Logical test:\u00a0 <\/span>A value or logical expression that can be evaluated as TRUE or FALSE<\/p>\r\n

Value if true:\u00a0 <\/span>[optional]\u00a0 <\/span>The value to return when logical test evaluates all to TRUE.<\/p>\r\n

Value if false: [optional]\u00a0 <\/span>The value to return when logical test evaluates one or more is FALSE<\/p>\r\n

EXERCISE<\/b> (This isn\u2019t graded, but you might find it useful before completing your assignment.)<\/p>\r\n

If evaluating a student based on lab scores and test scores, this function will automatically assign a True or False to that student.\u00a0 <\/span>You would be testing the scores themselves for each student and then returning either \u201cTrue\u201d or \u201cFalse\u201d<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n

AND Function Test<\/b><\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Name<\/b><\/p>\r\n<\/td>\r\n

\r\n

Lab Score<\/b><\/p>\r\n<\/td>\r\n

\r\n

Test Score<\/b><\/p>\r\n<\/td>\r\n

\r\n

Result<\/b><\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Anderson<\/p>\r\n<\/td>\r\n

\r\n

92<\/p>\r\n<\/td>\r\n

\r\n

60<\/p>\r\n<\/td>\r\n

\r\n

FALSE<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Bell<\/p>\r\n<\/td>\r\n

\r\n

85<\/p>\r\n<\/td>\r\n

\r\n

79<\/p>\r\n<\/td>\r\n

\r\n

TRUE<\/p>\r\n<\/td>\r\n<\/tr>\r\n

\r\n

Cartridge<\/p>\r\n<\/td>\r\n

\r\n

65<\/p>\r\n<\/td>\r\n

\r\n

92<\/p>\r\n<\/td>\r\n

<\/td>\r\n<\/tr>\r\n
\r\n

Delaney<\/p>\r\n<\/td>\r\n

\r\n

79<\/p>\r\n<\/td>\r\n

\r\n

61<\/p>\r\n<\/td>\r\n

<\/td>\r\n<\/tr>\r\n
\r\n

Finberg<\/p>\r\n<\/td>\r\n

\r\n

99<\/p>\r\n<\/td>\r\n

\r\n

89<\/p>\r\n<\/td>\r\n

<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n