BINOM.DIST Function

BINOM.DIST returns probability as a decimal number between 0 and 1. Binary data shows up when an observation can be placed into only two categories. For example, when tossing a coin, the result can only be heads or tails. Or, when rolling a die, the result can either be 6 or not 6. Since a die has six sides, the probability of rolling a 6 is 1/6, or 0.1667. The probability of rolling one 6 in 10 trials is about 32%....

April 14, 2025 · 1 min · 95 words · Jared Melendez

BITAND Function

AND returns TRUEonly if all the conditions are met. If any conditions are not met, the AND function returns FALSE. The AND function is commonly used with other… BITOR Function

April 14, 2025 · 1 min · 30 words · Dr. Carlos Anderson

BITLSHIFT Function

How It Works The shift_amount can either be positive or negative. If a negative number is provided, the bits are shifted to the right instead. Related functions BITRSHIFT Function

April 14, 2025 · 1 min · 29 words · Rebecca Collins PhD

BITOR Function

OR returns TRUEif any condition is TRUE. If all conditions are FALSE, the OR function returns FALSE. The OR function is often used with the IF function and can be combined…

April 14, 2025 · 1 min · 31 words · Amanda Russo

BITRSHIFT Function

How It Works Theshift_amountcan either be positive or negative. If a negative number is provided, the bits are shifted to the left instead. Related functions BITLSHIFT Function

April 14, 2025 · 1 min · 27 words · Danielle Green

BITXOR Function

it’s possible for you to have one or the other, but not both. If neither is TRUE, XOR also returns FALSE.

April 14, 2025 · 1 min · 21 words · Jorge Snyder

Biweekly pay schedule

A biweekly pay schedule means employees are paid every two weeks on a given day of the week. We can solve this problem with the SEQUENCE function, as explained below. When properly formatted, they display as dates. “Fri”) before the date to make it easy to verify correct results. We have to use a bit of trickery here to get WORKDAY to check the date returned by SEQUENCE. We do this by asking WORKDAY for the workdaypreviousto the date + 1....

April 14, 2025 · 1 min · 91 words · Mr. Keith Gonzalez

BMI calculation formula

Explanation This example shows one way to calculate BMI (Body Mass Index) in Excel. The first step, therefore, is to capture this information in commonly used units. This is done in columns B (feet) C (inches) and D (pounds). Alternatives The formulas used above can be simplified somewhat. When Excel evaluates the formula, this operation happens before the CONVERT function runs. Not quite as readable, but more compact. Note: Excel’sorder of operationsmakes it unnecessary to wrap B5*12 in parentheses....

April 14, 2025 · 1 min · 117 words · Samuel Novak

Bond valuation example

The $1,000 will be returned at maturity. Finally, the required rate of return (discount rate) is assumed to be 8%. The value of an asset is the present value of its cash flows. ThePRICE functioncan be used to calculate the “clean price” of a bond on any date. More detail For a more detailed explanation of bond valuation,see this articleontvmcalcs.com. FV Function PRICE Function

April 14, 2025 · 1 min · 64 words · Christopher Mason

Boolean algebra in Excel

AND logic corresponds tomultiplication. Anything multiplied by 0 is 0, and anything multiplied by 1 remains unchanged. If I multiply A times B, it’s possible for you to see how this works. To get a result of 1, both A and B must be 1. All other combinations return zero. To check this result, I can use theAND functionto evaluate A and B. AND returns either TRUE or FALSE. To get a 1 or 0, I can use a double negative....

April 14, 2025 · 2 min · 272 words · Lauren Moreno

Boolean logic

TheSUMPRODUCT functionis a good example.

April 14, 2025 · 1 min · 5 words · Alicia Brown

Boolean operations in array formulas

Boolean operations are a key building block in the world of dynamic array formulas. To illustrate, let’s look at some simple order data. Given the data shown, how can we total orders from Texas using an array formula? TRUE values indicate orders where the state is “tx” or Texas. FALSE values represent any other state. This is because the SUM function simply ignores the logical values TRUE and FALSE. We need to give Excel a little kick to coerce the TRUE and FALSE values to 1 and 0....

April 14, 2025 · 2 min · 224 words · Ashley Smith

Break ties with helper column and COUNTIF

The problem is that there are some duplicate values in the estimate column. In the example shown, Metrolux and Diamond both have the same estimate of $5000. from a set of numeric data. you’re able to use INDEX to retrieve individual values, or entire rows and columns. MATCH supports approximate and exact matching, andwildcards(* ?)

April 14, 2025 · 1 min · 55 words · Ryan Cox