My formula in cell C10 is: =IF(C7="Purchase",B10,""). C7 is currently blank, but the formula is calculating it as TRUE and inputting the value from B10. The Logical test is not TRUE, so what is going on?