Problem: As shown in Fig. 595, you need to calculate a 10 percent bonus on sales greater than $1000.00, but no commission is paid on sales less than that amount. While you can use the IF function, is there an easier (and faster) way?
Note: Click any image for a larger view.
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 can learn about these in later tutorials found here at Bright Hub.
Functions Discussed: =IF()
By the way, an IF function would work just as well, too, if you prefer going that route. To learn more about IF constructions, please see How to Use the IF Function in Microsoft Excel 2007. Even though this tutorial was written with Excel 2007 in mind, the technique works in all versions of the spreadsheet software.