
Chapter 4 Working with Conditions94
Example 4.4 Seven-Segment Display
In this example, we will try to integrate our knowledge of conditional calculations and
formatting by creating a worksheet that shows the digit present in cell A1 through
a display commonly known as seven-segment display. These displays are common
to many household appliances such as microwaves, clock radios, and calculators, and
are used to display numeric information such as time and temperature. As the name
implies, a seven-segment display is made of seven segments arranged in a particular way
as shown in Figure 4.18. By selectively turning on and off different segments, ...