The correct formula is: `=IF(G15=TRUE,1,0)` That is, drop the quotes around `TRUE`.