Glossary: AI at Work Basics

Spreadsheet functions (SUM, IF, AND)

Also written: SUM, =SUM, IF, AND, IF function

SUM adds up numbers, such as =SUM(D2:D200). IF gives one result if a condition is true and another if not (for example free shipping when C2 is 50 or more), and AND is true only when every condition inside it is true.