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


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

7 Feedbacks on "Boolean In Excel As An Alternative To If Conditions"

victor

Sir,
I want to learn how to create sheets within a sheet in excel.For instance if i click on cell A2(labeled discharge)it should open a workbook containing that information.



Useful-tips-for-household-utensi.webnode.com

Check out their burr grinder and find out how grinding your own coffee beans can make all of the
difference within the world. These days you are able to also buy espresso machines that
brew strait into 1 or two thermal coffee cups (think Cuisinart Two To Go Coffee Maker).
Look for any clean, sleek design and good performance.



kickstarter.com

Dust mites in bedding are killed within ten minutes by dryer heat,
but it can be virtually impossible to get dust mites and their waste out
of mattresses and pillows. In general the ionic and germicidal purifiers emit little to no noise, they are compact
in size and best of all- no filters to change.
They take up much less power and therefore marginal
electric charges.



Willard

If so, you may could benefit from learning about the new, high
quality coffee machines available today. Coffee lovers have come a long way because
the days when retired NBL players were plugging coffee makers on television. With lesser cleaning steps and much less time for brewing, these devices can create great differences in connection with preparation of
great flavor beverage which that suits you each morning.



Connie

A_The Stephen Joseph backpack will solve this problem for it comes with a personalize design. In that case you’ll probably pack
your bag with lunch and various handy necessities.
When our level of motivation is low we are a like a car without fuel.



www.memotoo.com

Ideas which can do justice to the emotions associated with every event.

You can have the bunny holding a gift basket in place of
the egg basket for a real easter treat for moms, grandmothers or even a
thoughtful easter hostess gift. This way they add the wet ingredients and enjoy the cookies.



Mittie

If you are looking for kitchen cookware to stay in your life for a while, invest in something a bit heavier such as copper or stainless cookware.
On the website, we will get hundreds of products and interesting collection. The storage
of the pans is far easier when you may have this potential at your disposal.