MS Excel Tricks

Reference the same cell (A1 in this case) no matter where the equation moves to :

$A$1

Convert boolean TRUE or FALSE to a number (1 or 0 respectively):

= TRUE*1
= FALSE*1
Advertisements