In column H, find women who are white or have over 12 years of school In column I, find women who match the previous condition and get unemployment insurance benefits. In cell A28, define a filter to return only the rows that match conditions in column I. please show the excel solution of "is white or has over 12 years experience"and " is white or has over 12 years experience) and gets unemployment insurance benefits?",thank you :)
The third logical operator is OR(). This returns TRUE when any of its inputs is TRUE.
For example, OR(FALSE, TRUE, FALSE) returns TRUE since the second input is TRUE, but OR(FALSE, FALSE, FALSE) returns FALSE since all its inputs are FALSE.
In column H, find women who are white or have over 12 years of school
In column I, find women who match the previous condition and get unemployment insurance benefits.
In cell A28, define a filter to return only the rows that match conditions in column I.
please show the excel solution of "is white or has over 12 years experience"and " is white or has over 12 years experience) and gets unemployment insurance benefits?",thank you :)
Has young kids? | Is head of household? | Gets unemployment insurance benefits? | Is white or has over 12 years experience? | (Is white or has over 12 years experience) and gets unemployment insurance benefits? |
FALSE | TRUE | TRUE | ||
FALSE | FALSE | FALSE | ||
FALSE | TRUE | TRUE | ||
FALSE | FALSE | FALSE | ||
TRUE | TRUE | TRUE | ||
TRUE | FALSE | FALSE | ||
FALSE | TRUE | FALSE | ||
FALSE | TRUE | FALSE | ||
FALSE | FALSE | TRUE | ||
FALSE | FALSE | TRUE | ||
FALSE | FALSE | TRUE | ||
TRUE | FALSE | FALSE | ||
FALSE | FALSE | TRUE | ||
FALSE | TRUE | FALSE | ||
TRUE | FALSE | TRUE | ||
TRUE | FALSE | TRUE | ||
TRUE | TRUE | FALSE | ||
FALSE | FALSE | FALSE | ||
TRUE | TRUE | TRUE | ||
FALSE | FALSE | TRUE | ||
FALSE | FALSE | TRUE | ||
FALSE | FALSE | FALSE | ||
FALSE | FALSE | TRUE | ||
TRUE | FALSE | FALSE | ||
Has young kids? | Is head of household? | Gets unemployment insurance benefits? | Is white or has over 12 years experience? | (Is white or has over 12 years experience) and gets unemployment insurance benefits? |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
In cell I2, define a filter on the whole dataset (columns A to G),