Microsoft Excel: Replace IF Function With Boolean Logic

Problem: As shown in Fig. 595, you need to calculate a 10 percent bonus on sales greater than $1000.00.

See all Microsoft Excel tips

Strategy: You can use the Boolean logic facts to do this calculation without an IF function. Remember that a Boolean test that results in a TRUE is treated as a 1 and a FALSE statement is treated as a 0. Thus, you could multiply the calculation E2*0.1 by the Boolean test (E2>1000), as shown in Fig. 596.

Summary: This formula combines a math calculation with a Boolean test to produce a valid result. Using these types of calculations is one key to using conditional sums with two conditions. You will learn about these in the next chapter.

Functions Discussed: =IF()