SWITCH Formula in Excel ( 5 Examples )

SWITCH Formula in Excel ( 5 Examples )

SWITCH Formula in Excel ( 5 Examples )

Practice File Link :-

https://www.mediafire.com/file/aj1crtmjanmq4kw/switch+function.xlsx/file

Example 1 ( Sales Report ) :-

=switch(C3,1,”Poor”,2,”Average”,3,”Good”,”Excellent”)

C3=Rating Cell Ref

Example 2 ( Student Report ) :-

=switch(True, B3>=80,”A”,B3>=70,”B”,B3>=60,”C”,”D”)

B3=Average Cell Ref

Example 3 ( State Code ) :-

=switch(A3,”Andhra Pradesh”,”AP”,”Kerala”,”KL”,”Delhi”,”DL”,Telangana”,”TG”)

A3=State Name Cell Ref

Example 4 ( Commission Report ) :-

=switch(True,A2>50,000,10%,A2>30,000,5%,A2>10,000,3%,0%) X A2

A2=Sales Cell Ref

Example 5 ( Using Dates ) :-

=switch(Weekday(A4,2),6,”Weekend”,7,”Weekend”,”Weekday”)

A4=Date Cell Ref

durgaprasad

leave a comment

Create Account



Log In Your Account