O'Reilly logo

Take Control of Numbers by Sharon Zardetto

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

IF Statements and Logical Operators

Back in the original Star Trek days, my grandfather made fun of “Dr. Spock’s” funny ears—conflating the Enterprise science officer with the baby-care expert who came to fame a decade before. I loved Mr. Spock for his adherence to logic above all else (and his cocked-eyebrow reaction to Captain Kirk’s lack of same). It’s probably not coincidental that when I first encountered computer programming, I was most enamored of its use of logical functions, and that affection carried over to their use in spreadsheets.

But, enough history! This chapter starts by delving into the concept of truth, as interpreted by a spreadsheet formula, with a quick side trip about Comparison Operators. Then (with apologies to my vegan ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required