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

댓글

이 블로그의 인기 게시물

(독후감) 종이 동물원 - 켄 리우

자주 꾸는 악몽 (외)

(독후감) 모두 거짓말을 한다.