spreadsheet.md

   1 ---
   2 title: Spreadsheet functions
   3 tags: [WIP]
   4 layout: 2017/sheet
   5 ---
   6
   7 ### If
   8
   9 ```
  10 =IF(test, then, else)
  11 =IF(EQ(A1, "paid"), "true", "false")
  12 ```
  13
  14 ### Comparators
  15
  16 ```
  17 =EQ(a,b)
  18 =NE(a,b)
  19 =GT(a,b)
  20 =GTE(a,b)
  21 =LT(a,b)
  22 =LTE(a,b)
  23 ```
  24
  25 ### Math
  26
  27 ```
  28 =POW(2, 32)   # 2^32
  29 =SIN() ACOS() etc
  30 =CEILING(n,sig,mode)
  31 =FLOOR(n,sig,mode)
  32 =INT(n)
  33 ```
  34
  35 ```
  36 =SUM(range)
  37 ```
  38
  39 ```
  40 =SUMIF(range, criteria, sum_range)
  41 =SUMIF(A1:A5, ">300", B1:B5)          # if A# is >300, use B#
  42 ```
  43
  44 ### Core
  45
  46 ```
  47 =TO_DATE(number)
  48 ```
  49
  50 ### Vlook
  51
  52 ```
  53 =VLOOKUP(value, range, column_index)
  54 ```