💡 The Hidden Numbers

Goal: Multiply logic by money.
In Excel math, TRUE = 1 and FALSE = 0.

TRUE × $100 = $100
Ready...

💻 Formula Structure

=TRUE() or =FALSE()
  • Concept: These are Boolean values.
  • Math: Any math operation (+, -, *, /) forces them to become numbers (1 or 0).
  • Double Negative (--): A common trick (--A1) to force text-numbers or booleans into real numbers.
-- Calculate Bonus: (Met Target?) * $100
=TRUE * 100
Total Bonus:
-

⚠️ Common Pitfalls

🚫 Text "TRUE" vs Logic TRUE
Typing "TRUE" in a cell is usually auto-converted. But in formulas, "TRUE" (text) is NOT the same as TRUE() (logic).
🚫 SUM won't count them
=SUM(TRUE, TRUE) is 2. But =SUM(A1:A2) where cells contain TRUE is 0. Excel ignores text/bools in ranges unless you convert them first (e.g. using --).