cheatsheets/spreadsheet.md at master

mirror of https://github.com/rstacruz/cheatsheets.git synced 2026-04-27 03:00:45 -04:00

Files

Rico Sta. Cruz 511de900ba Formatting updates (#2133 )

- Update some sheets which have very long sections
- Remove `layout: 2017/sheet` (everything has the same layout now)
- Remove outdated sheets

2024-04-03 18:30:24 +11:00

title, tags

title

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

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

=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#

=TO_DATE(number)

=VLOOKUP(value, range, column_index)