Related Posts
Telugu Video Tutorials – Notes – Shortcuts
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