I am using the MID function (=MID($N2,2,1)) to split a two digit number into
two different cells and then summing them (i.e. 10 into two cells totaling 1,
or 23 totaling 5). There isn't always a two digit number to split into two
cells, so I get a #VALUE instead. That response carries over into following
formula. I would like to know if there is a way to make the #VALUE become a
zero.