Functions of Google Spreadsheet that I used for balancing game.

Function list is here. INDEX: show the content of indicated row & column in the selected range. example: = INDEX ( AM12:AN19 , 5 , 1 ) => INDEX(selected range, indicated row, indicated column) Switch & IFS 1) I would like to something that return a value according to its range. - Usually in C#, it is possible to use Switch operator and range. - But I couldn't find the way to do in Google Spreadsheet function. 2) What I want is 'return out of chart' if the point is less than 800, and 'return 100 if point is between 800 and 1000. The solution is like this - IFS ( AJ12 < 'b1'!B14 , "순위권 밖" , AND ( AJ12 >= 'b1'!B14 , AJ12 < 'b1'!B13 ) , RANDBETWEEN ( 91 , 100 ) ) - IFS(first condition, value for return, second condition, value for return) - It seems for me there is no syntax like 'AJ12> B14 && AJ< B13) - Instead I use like this 'AND( AJ12> B14, AJ< B...