[go: up one dir, main page]
Scribd
Upload
5 views11 pages

Switch Function Start

The document provides an overview of the Excel SWITCH function, demonstrating how to assign actions based on employee review scores. It includes examples of employee reviews, corresponding actions, and a breakdown of employee test scores and bonus criteria by country. Additionally, it emphasizes that the content is copyrighted and cannot be reproduced without permission from Career Principles Ltd.

Uploaded by

mamuhammed216
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views11 pages

Switch Function Start

The document provides an overview of the Excel SWITCH function, demonstrating how to assign actions based on employee review scores. It includes examples of employee reviews, corresponding actions, and a breakdown of employee test scores and bonus criteria by country. Additionally, it emphasizes that the content is copyrighted and cannot be reproduced without permission from Career Principles Ltd.

Uploaded by

mamuhammed216
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 11

Excel SWITCH

Excel SWITCH Fun


Get 10% OFF our course using coupon code EMAIL

Get our Excel for Business & Finance Co


Go to Sheet 1 -> here
Made by Career Principles Ltd.
Note
All content is copyright material of Career Principles Ltd.
This Excel model may not be reproduced or distributed by any means, including printing,
screencapturing, or any other method without the prior permission of the publisher.
on
Customer
Employee Action
Reviews
Bill 5
Mike 4
Sarah 2
Josh 3
Sam 5
Nick 2
Hanna 1
Customer
Employee Action
Reviews
Bill 5 Bonus
Mike 4 Congrats
Sarah 2 Meeting
Josh 3 Nothing
Sam 5 Bonus
Nick 2 Meeting
Hanna 1 Critical

Customer
Employee Action
Reviews
Bill 5
Mike 4
Sarah 2
Josh 3
Sam 5
Nick 2
Hanna 1
Customer
Employee Action
Reviews
Bill 5 Bonus =SWITCH(C3,5,"Bonus",4,"Congrats",3,"Nothing",2,"Mee
Mike 4 Congrats
Sarah 2 Meeting
Josh 3 Nothing
Sam 5 Bonus
Nick 2 Meeting
Hanna 1 Critical

Customer
Employee Action
Reviews
Bill 5
Mike 4
Sarah 2
Josh 3
Sam 5
Nick 2
Hanna 1
s",3,"Nothing",2,"Meeting",1,"Critical","No Review")
Customer
Employee Action
Reviews
Bill 5 Bonus =SWITCH(C3,5,"Bonus",4,"Congrats",3,"Nothing",2,"M
Mike 4 Congrats
Sarah 2 Meeting
Josh 3 Nothing
Sam 5 Bonus
Nick 2 Meeting
Hanna 1 Critical

Customer
Employee Action Review
Reviews
Bill 5 1
Mike 4 2
Sarah 2 3
Josh 3 4
Sam 5 5
Nick 2
Hanna 1
us",4,"Congrats",3,"Nothing",2,"Meeting",1,"Critical","No Review")

Action

Critical
Meeting
Nothing
Congrats
Bonus
Employee Test Score Result
Bill 45
Mike 90
Sarah 75
Josh 13
Sam 88
Nick 67
Hanna 54

Employee Test Score Result


Bill 45
Mike 90
Sarah 75
Josh 13
Sam 88
Nick 67
Hanna 54
Criteria
Country Bonus
France Fixed 8k
Germany 25% of Salary
Spain Fixed 10k
USA 20% of Salary

Name Country Salary Bonus


Bill France 50,000
Mike France 40,000
Sarah Spain 32,000
Josh Germany 55,000
Sam Germany 55,000
Nick France 42,500
Hanna USA 75,000
Jess USA 68,000

You might also like