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.

## Bookmarks