DEV Community

Lam
Lam

Posted on

Spreadsheet Functions Cheat Sheet

#spreadsheet #cheatsheet

Vlook 

=VLOOKUP(value, range, column_index)
Enter fullscreen mode Exit fullscreen mode

Core 

=TO_DATE(number)
Enter fullscreen mode Exit fullscreen mode

Math 

=POW(2, 32)   # 2^32
=SIN() ACOS() etc
=CEILING(n,sig,mode)
=FLOOR(n,sig,mode)
=INT(n)
Enter fullscreen mode Exit fullscreen mode 
=SUM(range)
Enter fullscreen mode Exit fullscreen mode 
=SUMIF(range, criteria, sum_range)
=SUMIF(A1:A5, ">300", B1:B5)          # if A# is >300, use B#
Enter fullscreen mode Exit fullscreen mode

Comparators 

=EQ(a,b)
=NE(a,b)
=GT(a,b)
=GTE(a,b)
=LT(a,b)
=LTE(a,b)
Enter fullscreen mode Exit fullscreen mode

If 

=IF(test, then, else)
=IF(EQ(A1, "paid"), "true", "false")
Enter fullscreen mode Exit fullscreen mode

Reference

Top comments (0)

Read next

nishanthan-k profile image

TypeScript Event Types and Event Handling in React: A Complete Guide for Beginners

Nishanthan K -

patrick_61cbc6392b72286f6 profile image

How to Debug Java Applications Using IDEs

Patrick -

luisdev07 profile image

Fundamentos de Programación: Una Guía para Principiantes

Luis -

hambalee profile image

OpenShift คืออะไร? จุดเด่นและประโยชน์ของ OpenShift มีอะไรบ้าง

hambalee -