PRICEMAT Function in Excel: Price of a Security Paying Interest at Maturity
PRICEMAT returns the price per 100 of a security that pays interest at maturity.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
YIELDDISC Function in Excel: Yield of a Discounted Security
YIELDDISC Function in Excel: Yield of a Discounted Security
FinanceLevel: ExpertAvailable in: Excel 2007+YIELDDISC returns the annual yield of a discounted security such as a T-bill.Syntax=YIELDDISC(settlement.
Read article →DISC Function in Excel: Discount Rate of a Security
DISC Function in Excel: Discount Rate of a Security
DISC works out the discount rate when you know the purchase price and redemption value — commercial paper, bill discounting.
Read article →STDEVPA Function in Excel: Population SD Counting Text and TRUE/FALSE
STDEVPA Function in Excel: Population SD Counting Text and TRUE/FALSE
StatisticsLevel: IntermediateAvailable in: Excel 2007+STDEVPA is the population version of STDEVA.Syntax=STDEVPA(value1, [value2], ...)ArgumentWhat it.
Read article →TBILLYIELD Function in Excel: Treasury Bill Yield
TBILLYIELD Function in Excel: Treasury Bill Yield
FinancialLevel: ExpertAvailable in: Excel 2007+TBILLYIELD returns the yield of a T-bill from its price.Syntax=TBILLYIELD(settlement, maturity.
Read article →Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
Read article →TBILLPRICE Function in Excel: Treasury Bill Price
TBILLPRICE Function in Excel: Treasury Bill Price
TBILLPRICE returns the price per 100 of a T-bill from its discount rate (US convention, 360-day year).
Read article →DOLLARFR Function in Excel: Decimal Prices to Fractions
DOLLARFR Function in Excel: Decimal Prices to Fractions
DOLLARFR is the reverse of DOLLARDE: 1.125 with fraction 16 becomes 1.02 (1 and 2/16).
Read article →PERMUTATIONA Function in Excel: Arrangements With Repeats
PERMUTATIONA Function in Excel: Arrangements With Repeats
PERMUTATIONA counts ordered arrangements where items can repeat: a 4-digit PIN has PERMUTATIONA(10,4) = 10,000.
Read article →MULTINOMIAL Function in Excel: Ways to Split Into Groups
MULTINOMIAL Function in Excel: Ways to Split Into Groups
MathLevel: ExpertAvailable in: Excel 2007+MULTINOMIAL counts ways to divide items into groups of given sizes.Syntax=MULTINOMIAL(number1, [number2].
Read article →FACTDOUBLE Function in Excel: Double Factorial
FACTDOUBLE Function in Excel: Double Factorial
MathLevel: ExpertAvailable in: Excel 2007+FACTDOUBLE multiplies every other number: 7!! = 7 × 5 × 3 × 1.Syntax=FACTDOUBLE(number)ArgumentWhat it.
Read article →COMBINA Function in Excel: Combinations With Repeats
COMBINA Function in Excel: Combinations With Repeats
COMBINA counts selections where the same item can be chosen more than once — scoops of ice cream from four flavours.
Read article →