I fixed it. I didn't change the above formula but went into the other
cells and adjusted the formula. I had "" (double quotes) in the FALSE
argument instead of just putting 0 (number zero). This then adds a
zero instead of a BLANK which equals to a space but Excel doesn't
represent that as a value but as a string. Anyway, all works now.


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=491066