Challenge: You want to become a guru at Excel formulas. To master conditional computing formulas, you need to understand Boolean logic facts.
Let’s say that you need to design a formula to calculate a 2% bonus. The bonus is paid if revenue is > 20,000 and gross profit percentage is > 50%. The bonus is also paid whenever the sales rep name is Joey.
Understand Boolean Logic: False Is Zero
Challenge: You want to become a guru at Excel formulas. To master conditional ... Read More..
Popular Posts
-
Challenge: You want to build a formula to return the first non-blank cell in a row. Perhaps columns B:K reflect data at various points in t... -
Challenge: Calculate how many workdays fall between two dates. Excel's NETWORKDAYS function does this if you happen to work the five da... -
Challenge: In Figure 7, someone set up a worksheet with dollars in rows 2, 4, 6, 8, and so on and percentages in rows 3, 5, 7, 9, and so o... -
Challenge: While IFand other functions that expect logical tests can easily convert TRUE and FALSE values to 1s and 0s, the SUMPRODUCT ... -
Challenge: You want to become a guru at Excel formulas. To master conditional computing formulas, you need to understand Boolean logic fac... -
You’ve used Excel for quite a while, but you probably never thought of it as an object. The more you work with VBA, the more you view Excel... -
Taking the First Steps This tutorial describes the steps you take prior to recording the macro. In other words, you need to make a few pre... -
Before you can call yourself an Excel programmer, you must go through the initiation rites. That means you need to make a small change so E... -
Challenge: Your IT department sends you a file with unit price and quantity sold. You need to calculate total revenue. You usually add a n... -
Challenge: The NETWORKDAYS and WORKDAY functions can take a list of company holidays as the third argument. If you store the list of holi...
Footer 1
