Boolean In Excel As An Alternative To If Conditions

Excel function tutorials

I got an interesting email the other day from a reader who was looking to add Boolean logic to spreadsheets. First, you might wonder what Boolean is:

-boolean is a data type with only two possible values: true or false – in excel the two possible values are 0 (false) or 1 (true)

How Boolean Logic Can Be Used In Excel

In some cases, you might want to use it instead of “if” conditions. The example he gave me was:

=(8>3)*(1000/10) which will give 10

Basically, in this case, 8>3 is a Boolean data which is “true” so it equals 1. You’d then end up with a result of 10.

Here is an example. Suppose that you have a sales staff that makes a commission of 5% on all sales on one condition. They must make at least $3,000 worth of sales in that week to make a commission. If they don’t, the commission is $0.

As you can see, this is a perfect case for Boolean. What I’ll do is:

=(D3>3000)*D3*0.05

See the end result here:

There are many different possibilities but as you can see, this makes it very easy to understand and play with. The key is to require a “numeric value” that can be multiplied

Have you ever used or are you considering using Boolean based formulas in excel?

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

Related posts:


Fatal error: Call to undefined function related_posts() in /home/exp571/public_html/wp-content/themes/a blog beyond theme/single.php on line 96