Menu

gitpiper

Spreadsheet functions Cheat Sheet in July 2024

Last Updated: 13 July 2024

README.md

If

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

Comparators

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

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)

338+ more cheat sheets for you in July 2024

Subscribe to our Newsletter

Subscribe to get resources directly to your inbox. You won't receive any spam! ✌️

© 2024 GitPiper. All rights reserved

Rackpiper Technology Inc

Company

About UsBlogContact

Subscribe to our Newsletter

Subscribe to get resources directly to your inbox. You won't receive any spam! ✌️