MAKING DECISIONS WITH IF

CUSTOMER NO. OF ORDEMEMBER TOTAL DISCOUNT

Cody Gill 16 YES $683.00
Randall Hoffman 20 YES $650.00
Suzanne Collier 15 YES $534.00
Douglas Powers 19 NO $642.00
Laura Sharp 10 NO $632.00
Darren Stephens 18 YES $600.00
Madeline Casey 15 YES $571.00
Kelli Delgado 12 NO $559.00
Latoya Lyons 14 NO $566.00
Mildred Morgan 11 YES $540.00
Anna Jones 17 YES $509.00
Sally Baker 20 NO $650.00
DISCOUNT
600 15%
IFS, AND/OR

Sales >30000 and <45000

True = "Yes", False="Review"

Item Sales IF, AND

Konika Watch $48,737
BassIt Headphones $24,578
Micro Tablet $49,160
FitByte Tracker $46,115
Joy MultiReach Mop $27,224
SonicBoost Toothbrush $35,821
Harley Bag $45,503
ShakeIt Bottle $43,783
Series C Mens Shaver $33,770
Scott and Tate Mens Jacket $47,592
Moreton Antivirus $34,837
Botany Skincare Package $43,678
Aroma Demister $28,903
Essentual Oils $36,655
Woodworks Candle $38,633
 Sales >30000 AND <45000 = "Good" Sales >=45000 OR <=30000 then "Symbol"
Sales >=45000 then "Excellent"
Sales <30000 then "Review"

IFS, AND IF, OR

 TARGETS
30000
45000

SYMBOL
©
β
TWO-WAY LOOKUP

Company Jan Feb Mar Apr May Jun Jul

GoExplore $37,050 $22,472 $69,908 $28,281 $44,450 $28,200 $36,989
Wanderlust $66,608 $56,572 $36,501 $62,743 $26,185 $47,104 $38,236
Footsteps $27,009 $55,745 $62,238 $22,640 $52,733 $40,612 $69,215
Air2Go $55,961 $37,989 $24,726 $24,205 $37,416 $63,802 $27,566
Sun and Sails $44,232 $31,764 $49,977 $67,359 $30,923 $57,690 $25,920
Trekker $36,701 $35,848 $36,841 $49,089 $30,444 $58,634 $39,784
Travelo $55,773 $40,146 $45,990 $21,954 $69,974 $30,459 $21,739
Flight Shop $68,442 $46,358 $30,769 $35,647 $50,612 $47,615 $33,033

Company Footsteps
Month Aug

Revenue 69455 69455

REVENUE 69455
Aug Sep Oct Nov Dec
$23,757 $28,497 $65,229 $33,392 $50,842
$50,783 $33,699 $32,636 $60,948 $24,089
$69,455 $59,488 $29,605 $57,577 $49,366
$20,994 $27,464 $45,860 $20,177 $36,052
$37,345 $57,802 $68,776 $20,474 $59,249
$37,720 $59,486 $69,624 $43,410 $52,168
$41,829 $60,926 $21,751 $56,854 $63,382
$50,562 $61,557 $37,175 $31,426 $29,220

Travelo
Footsteps
8 69455 7
CHOOSE RANDOM

Name Team Assignment Choices

Natasha Team D Team A
Angelica Team C Team B
Dixie Team A Team C
Alexander Team B Team D
Lorena Team A
Crystal Team B
Jamie Team C
Wayne Team A
Frances Team A
Kayla Team B
Matt Team D
Jody Team B
Margie Team C
Julia Team C
Simon Team B
MOST FREQUENT

Name Result
Natasha 1 1
Angelica 2 2
Crystal 3 3
Alexander 4 4
Angelica 2 2
Crystal 3 3
Natasha 1 1
Wayne 8 8
Frances 9 9
Kayla 10 10
Natasha 1 1
Jody 12 12
Angelica 2 2
Julia 14 14
Simon 15 15
Natasha 1 1
Crystal 3 3
Wayne 8 8
Crystal 3 3
Crystal 3 3
NAME SALARY JOB RATING TEAM
Bonnie Moss $42,478 5 Development
Cody Fletcher $33,305 4 Marketing
Moses Mcguire $37,956 1 Sales
Kathy Wong $43,043 2 IT
Constance Day $36,020 3.2 HR
Cornelius Warner $38,140 3 HR
Arthur Valdez $39,333 3 Finance
Maureen Newton $44,610 4.9 Marketing
Jennifer Kelly $41,487 5 Finance
Cristina Mccarthy $34,334 3 Special Projects
Lindsay Singleton $38,928 2 Marketing
CURRENT TEAM BONUS NEW SALARY BONUS NEW SALARY
#NAME? #NAME? $46,726 0% 0.1
#NAME? #NAME? #NAME? 8% #NAME?
#NAME? #NAME? #NAME? 0% #NAME?
#NAME? #NAME? #NAME? 1% #NAME?
#NAME? #NAME? #NAME? #N/A #NAME?
#NAME? #NAME? #NAME? 5% #NAME?
#NAME? #NAME? #NAME? 5% #NAME?
#NAME? #NAME? #NAME? #N/A #NAME?
#NAME? #NAME? #NAME? 10% #NAME?
#NAME? #NAME? #NAME? 5% #NAME?
#NAME? #NAME? #NAME? 1% #NAME?
JOB RATINGBONUS
5 10%
4 8%
3 5%
2 1%
1 0%
XLOOKUP

START DATE TEAM LOCATION NAME

1/12/2015 Development London Bonnie Moss
8/5/2015 Marketing Dublin Cody Fletcher
12/22/2015 Sales Frankfurt Moses Mcguire
3/13/2016 IT London Kathy Wong
3/16/2016 HR Dublin Constance Day
6/20/2016 HR Paris Cornelius Warner
7/27/2016 Finance Frankfurt Arthur Valdez
9/21/2016 Marketing London Maureen Newton
10/28/2016 Finance London Jennifer Kelly
2/15/2017 Special Projects Paris Bonnie Moss
4/13/2017 Special Projects Warsaw Cristina Mccarthy
4/19/2017 Marketing Dublin Lindsay Singleton
5/17/2017 Finance London Alexandra Sparks
5/23/2017 Sales Paris Eileen Moreno
6/30/2017 Sales Frankfurt Hannah Ryan
8/8/2017 Training and Development Warsaw Lynn Carpenter
2/18/2018 HR Warsaw Abel Parks
7/1/2018 Training and Development Warsaw Kathy Wong
7/17/2018 IT London Sonya White
8/29/2018 IT Paris Leonard Fuller
10/9/2018 Sales Dublin Gwendolyn Thomas
11/22/2018 Development Dublin Rose Huff
12/10/2018 Development Frankfurt Monique Bell
EXTRACING USERNAME AND DOMAIN FROM AN EMAIL ADDRESS

Name Email Address

Bonnie Moss bmoss@gmail.com
Cody Fletcher cody.fletcher@yahoo.com
Moses Mcguire moses@helloworld.come
Kathy Wong k_wong@hotmail.com
Constance Day constanceday@outlook.com
Cornelius Warner cwarner78@gmail.com
Arthur Valdez valdeza@hotmail.com
Maureen Newton mnewton@postmaster.com
Jennifer Kelly jen_kelly5@yahoo.com
N EMAIL ADDRESS

Username Domain
SUMMING AND COUNTING VALUES BASED ON MULTIPLE CRITERIA

MONTH MODEL COLOR REVENUE Criteria_1 Criteria_2 Criteria_3

Jan Audi Black $ 49,005 Apr
Jan Toyota Blue $ 30,289 Apr BMW
Jan Audi Silver $ 42,779 Apr BMW White
Jan Mercedes White $ 46,862 BMW Green
Feb BMW Green $ 58,222
Feb Toyota Blue $ 49,945 Criteria_1 Criteria_2 Criteria_3
Feb Mercedes White $ 47,689 Apr
Feb Audi Black $ 40,206 Apr BMW
Feb BMW Green $ 43,372 Apr BMW White
Mar Audi Silver $ 40,458
Mar Mercedes Black $ 64,929
Mar Toyota Red $ 54,552
Apr BMW Green $ 36,991
Apr BMW White $ 30,936
Apr Audi Black $ 33,807
Apr Toyota Red $ 58,674
Apr Audi Silver $ 39,257
Apr BMW White $ 47,974
Apr Mercedes Black $ 69,913
Revenue
$ 317,552
$ 115,901
$ 78,910
$ 101,594

Count
7
3
2
SUMMING AND COUNTING VALUES BASED ON MULTIPLE CRITERIA

Company 2013 2014 2015 2016 2017 2018 2019 2020

Company A $3,342 $2,136 $4,523 $3,474 $4,055 $4,849 $4,987 $3,931
Company B $3,621 $3,850 $3,071 $2,222 $1,321 $3,830 $2,989 $1,065
Company C $3,219 $4,683 $1,698 $3,842 $3,616 $4,703 $4,009 $3,986
Company D $1,386 $4,762 $3,061 $3,722 $2,246 $3,173 $2,329 $2,650
Company E $3,166 $3,192 $1,376 $4,745 $4,531 $2,657 $4,584 $4,096
Company F $2,813 $2,816 $3,804 $1,708 $4,772 $2,992 $4,434 $1,687
Company G $3,534 $3,589 $1,686 $4,775 $4,538 $4,105 $4,832 $1,881
Company H $4,407 $3,533 $3,371 $1,946 $1,609 $4,254 $3,399 $4,916
Company I $3,120 $1,151 $2,112 $3,847 $4,536 $1,134 $3,589 $4,812
Company J $1,767 $2,162 $3,161 $4,600 $2,667 $4,196 $2,967 $1,838
Company K $4,801 $3,608 $4,264 $4,346 $2,346 $2,570 $4,462 $3,402
Company L $3,152 $3,272 $2,542 $1,917 $3,470 $2,612 $1,311 $3,092
Company M $4,655 $3,635 $3,849 $3,841 $1,868 $3,872 $4,602 $1,522
Company N $1,820 $3,420 $3,628 $3,665 $4,697 $1,931 $3,441 $4,508
Company O $4,810 $2,353 $3,056 $3,568 $3,471 $2,155 $2,468 $2,073
Company P $4,060 $4,754 $3,167 $4,541 $1,722 $1,863 $3,332 $1,630
Company Q $2,139 $3,116 $4,216 $1,715 $1,015 $4,541 $2,034 $2,134
Company R $4,438 $2,346 $4,968 $3,296 $4,854 $3,216 $2,252 $2,474
Company Company B
Up to Year 2017
Sales $14,085