SCHOOL BOOKS


SCHOOL BOOKS




EXAM TIME TABLE 2018 -- +2 +1 10TH










Tamilnadu School Books Change for Academic Years


Standards


Academic year




2, 7, 10 & 12


2019-20


3, 4, 5 & 8


2020-21





STD - 1
STD - 2
STD - 3
STD - 4
STD - 5
STD - 6
STD - 7
STD - 8
STD - 9
STD - 10
STD - 11
STD - 12









.

CHOOSE EXCEL FORMULA

EXCEL FORMULA
Function Dictionary Function Examples Function Categories

CHOOSE

         
 
 
Index Value Result
1 Alan  =CHOOSE(C4,"Alan","Bob","Carol")
3 Carol  =CHOOSE(C5,"Alan","Bob","Carol")
2 Bob  =CHOOSE(C6,"Alan","Bob","Carol")
3 18%  =CHOOSE(C7,10%,15%,18%)
1 10%  =CHOOSE(C8,10%,15%,18%)
2 15%  =CHOOSE(C9,10%,15%,18%)
What Does It Do?              
This function picks from a list of options based upon an Index value given to by the user.
Syntax                
 =CHOOSE(UserValue, Item1, Item2, Item3 through to Item29)
Formatting              
No special formatting is required.
Example                
The following table was used to calculate the medals for athletes taking part in a race.
The Time for each athlete is entered.
The =RANK() function calculates the finishing position of each athlete.
The =CHOOSE() then allocates the correct medal.
The =IF() has been used to filter out any positions above 3, as this would cause
the error of #VALUE to appear, due to the fact the =CHOOSE() has only three items in it.
Name Time Position Medal
Alan 1:30 2 Silver  =IF(D30<=3,CHOOSE(D30,"Gold","Silver","Bronze"),"unplaced")
Bob 1:15 4 unplaced  =IF(D31<=3,CHOOSE(D31,"Gold","Silver","Bronze"),"unplaced")
Carol 2:45 1 Gold  =IF(D32<=3,CHOOSE(D32,"Gold","Silver","Bronze"),"unplaced")
David 1:05 5 unplaced  =IF(D33<=3,CHOOSE(D33,"Gold","Silver","Bronze"),"unplaced")
Eric 1:20 3 Bronze  =IF(D34<=3,CHOOSE(D34,"Gold","Silver","Bronze"),"unplaced")
 =RANK(C34,C30:C34)

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu plus1 all books free download, Tamilnadu 11th all books free download