Hi,

You could use a change event on the cells. Why not include an 'if' eg. =IF(C1="",1,2) so C1 is tested if anything exists before doing its calulation?