=IF(A2="",0,1)
This results in... if A2 is NULL, true result is 0, if false result is 1
See sample spread sheet and if I'm off base with what you are trying to do, let me know.
What you could do is insert columns C and D and then hide them, putting your results in a cell that isn't hidden.