wd DemoLes 7 - Students Meeting Minimum Qualifications for...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Students Meeting Minimum Qualifications for Scholarships Use AND function when all conditions must be met. AND(____, ______, _____, Applicant Scholarships Applicant Citizen/resident UnitsThisSemester GPA Major Units Completed Working toward degree Financial Need Association of Accountants Assoc. of Adm. Professionals Calif. Assoc.of Mortgage Brokers Mai y 6 3.5 RE 15 y y FALSE FALSE TRUE Jorge y 12 2.9 ACCT 19 y n FALSE FALSE FALSE Susan n 18 3.0 ACCT 12 y y TRUE FALSE FALSE Kit y 15 3.7 ACCT 6 y n TRUE FALSE FALSE Mei y 9 3.5 WDPR 24 y y FALSE TRUE FALSE Ying y 7 3.1 RE 19 y n FALSE FALSE TRUE John n 12 3.2 ACCT 24 y y TRUE FALSE FALSE Tori y 14 3.8 RE 15 y y FALSE FALSE TRUE Yelena y 12 3.4 WDPR 29 y y FALSE TRUE FALSE Martina n 9 2.9 RE 15 y y FALSE FALSE FALSE Try using conditional formatting for TRUEs.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
, ….)
Background image of page 2
Association of Accountants Citizen/resident UnitsThisSemester Minimum GPA 3 Major Acct Units Completed Working toward Degree yes Financial need Citizen/resident yes UnitsThisSemester Minimum GPA 2.5 Major WDPR Units Completed 15 Working toward Degree YES Financial need California Mortgage Brokers Citizen/resident UnitsThisSemester 3 Minimum GPA 3 Major RE Units Completed 6 Working toward Degree Financial need Association of Administrative Professionals
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Qualifications for Apartment Rental Apartment applicants must have at least one form of identification. Applicant
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 7

wd DemoLes 7 - Students Meeting Minimum Qualifications for...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online