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< B13), some value)

- it means if the value passes as true for both of condition in AND( ) then return some value.

To get the value from other sheet

= the name of other sheet '!' and cell number

like this = b1! B13