BITAND Function in Excel: Bitwise AND
BITAND compares numbers bit by bit. Useful for decoding status flags stored as one number.
Read article →DOLLARDE Function in Excel: Fractional Prices to Decimals
DOLLARDE Function in Excel: Fractional Prices to Decimals
DOLLARDE converts prices quoted in fractions (like 1 and 2/16) into decimals — still seen in some bond and commodity feeds.
Read article →ISPMT Function in Excel: Interest on Equal-Principal Loans
ISPMT Function in Excel: Interest on Equal-Principal Loans
ISPMT calculates interest for a loan where the principal is repaid in equal parts (not an EMI). Note the period argument starts at 0.
Read article →DURATION Function in Excel: How Sensitive a Bond Is to Rates
DURATION Function in Excel: How Sensitive a Bond Is to Rates
DURATION returns Macaulay duration in years. Roughly, a bond with duration 7 loses about 7% in price if rates rise 1% — which is…
Read article →FVSCHEDULE Function in Excel: Growth at Changing Rates
FVSCHEDULE Function in Excel: Growth at Changing Rates
FVSCHEDULE compounds an amount through a list of different rates — FD renewals, varying annual returns.
Read article →NOMINAL Function in Excel: Effective Rate Back to Nominal
NOMINAL Function in Excel: Effective Rate Back to Nominal
NOMINAL reverses EFFECT: it tells you the quoted annual rate behind an effective yield.
Read article →Slow Laptop? A 30-Minute Checklist Before You Buy a New One
Slow Laptop? A 30-Minute Checklist Before You Buy a New One
A practical order of checks for a slow Windows laptop: startup apps, disk space, storage type, RAM use, browser tabs, updates and overheating —…
Read article →CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC Function in Excel: Principal Repaid Over a Period
CUMPRINC totals the principal part of loan payments between two periods — how much of the loan you actually cleared this year.
Read article →ATAN2 Function in Excel: Angle From X and Y
ATAN2 Function in Excel: Angle From X and Y
ATAN2 returns the angle of a point, handling all four quadrants. Note Excel’s order is (x, y) — the reverse of many programming languages.
Read article →COS Function in Excel: Cosine of an Angle
COS Function in Excel: Cosine of an Angle
COS also expects radians. Seasonal models sometimes use SIN and COS of the month to capture yearly cycles.
Read article →SIN Function in Excel: Sine of an Angle
SIN Function in Excel: Sine of an Angle
SIN expects radians. Wrap degrees in RADIANS().
Read article →MDETERM Function in Excel: Determinant of a Matrix
MDETERM Function in Excel: Determinant of a Matrix
MDETERM returns the determinant. Zero means the equations have no unique solution.
Read article →