I entered 
 =MAX(IF(3:3<>"",COLUMN(3:3)))
into cell A2 which is empty and the cell value changed to '0'.

What is that calculating???

thanx