---
title: Spreadsheet functions
---

### If

    =IF(test, then, else)
    =IF(EQ(A1, "paid"), "true", "false")

### Comparators

    =EQ(a,b) NE()
    =GT() GTE() LT() LTE()
    
### Math

    =POW(2, 32)   # 2^32
    =SIN() ACOS() etc
    =CEILING(n,sig,mode)
    =FLOOR(n,sig,mode)
    =INT(n)

    =SUM(range)

    =SUMIF(range, criteria, sum_range)
    =SUMIF(A1:A5, ">300", B1:B5)          # if A# is >300, use B#

### Core

    =TO_DATE(number)

### Vlook

    =VLOOKUP(value, range, column_index)