Master 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 had come 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 first delves into the concept of truth, as interpreted by a spreadsheet formula, with a quick side trip to Review Comparison Operators; after that, we’ll ...

Get Take Control of Numbers, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.